Change Text Colour if Value is in a List Q
How would I change the Text colour of a cell to white (invisible) if
that Value in the cell is listed within a list?
For example I have a range of values in Sheet1 from A5:W30, if any of
these cells is contained within the list that is detailed on Sheet2
A1:A5, then I want to change those values in Sheet1 A5:W30 to White
Thanks
|