How would I conditionally format a group of 5 cells on the basis that one of the 5 cells is equal to any number of 10 possible conditions.
eg. If cell 3 of cells 1-5 is = x, then cell is light green background, but if y, z, a, b, c, d, e, f... it is another colour.
Need a macro?
Any help appreciated.
garth
eg. If cell 3 of cells 1-5 is = x, then cell is light green background, but if y, z, a, b, c, d, e, f... it is another colour.
Need a macro?
Any help appreciated.
garth