Hi
This must have been asked a million times before, but i can't find the answer, or the answers i thought might work didn't (XL2010).
It's quite simple, if a cell's value = 43, 56 or 99 turn blue. I want this for all of column F. (i have a lot more values but just using these as an example)
I've tried things like:
=OR(43, 56, 99)
=AND(...
and similar variations.
None of which generate an error, but the cells containing these values just remain with no fill.
Thanks
Bookmarks