Conditional formatting

[roofi]

Dear all,
Here is sample sheet attached. and question is inside.
please be appreciated if solved.

thanks

[humdingaling]

use formula to determine which cells to format
=$N$3>=20

then applies to
=$E$3:$M$3

[roofi]

humdingaling,
i cant understand.
please do in the file and attach back if possible
thanks

[humdingaling]

See attached

Change Cell N3 to test

[roofi]

It is good but
it does not work if i drag this formation down
PLease review
thanks

[humdingaling]

you question was
E3:M3 should be yellow if N3 >= 20

so you never asked for drag down .....

take away dollar sign from 3 to make =$N3>=20
your applies to should update with drag down

[roofi]

Great.................
Thanks Dear it is working now. Solved
sorry for the first time if i could not make a sense.