Hi,
I'm trying to write a conditional formatting formula that will shade a cell yellow if its value is contained in a different range of cells.
For instance, my value in F1 is "ABC"
I want to know if "ABC" exists in ANY cell A1:A10 or C1:C100.
If it is in either of these ranges, F1 should turn yellow.
Can you help? I've tried several things I would expect might work and no luck.
Thanks,
David
Bookmarks