apply conditional formatting
I want to use conditional formatting on other cells than the active one.
A1 thru F1 and H1 needs to turn red if G1 = L and
A! thru F1 and H1 needs to turn blue if G1 = W.
Any help would be appreciated. Thanks in advance.
Colby
|