Question

how can we control the conditional formatting

Answer 1

if you need to apply conditional formatting you need to go in home tab and at right area of tab you will find conditional formatting
It is a condition in which you can highlight cells according to their condition..

Answer 2

Select the range. ...Click the Home tab (if necessary) and from the Conditional Formatting dropdown (in the Styles group), choose New Rule. .... ...Enter OR($B3>5000,$B3<1500) in the formula control.