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