Change Cell Color On Condition Of Cell

[Sean]

I have tried using conditional formatting for this already and can not get it
to work I am wondering if there is something else or another way to look at
it.

I have a worksheet with columns A to H, if any individual cell reads OFF
which is set in cell validation as an option in a list box. Then I want that
cell to turn yellow, if it is changed to anything else then it should turn
back to clear.

Is there a way to do this?

Thanks,

Sean

[JakeyC]

Two ways, either:

Apply Conditional Formatting to your chosen cells and using 'Cell value
is' with 'equal to', enter the formula,

="OFF" and choose the format you want (yellow was it?)

OR

In Cell A1, apply Conditional Formatting using 'Formula Is' option and
in sert the formula, =IF(A1="OFF",TRUE,FALSE) and choose your format,
then AutoFill to the row you want.