apply conditional formatting
Hi,
-Select A1
-Menu Format COnditional Formating:
'Formula Is'
= ($G1="L")
Click Ok
- Now select A1 AND the other cells, ie A1:F1,H1
- menu Format Conditional Formating, The above Cond Format will already be
in place in the dialog (because A1 was also selected). So just Click OK
Remark: you could have done it in 1 shot by selecting A1:F1,H1 the first time.
Remark2: you can also now copy/PasteSpecial Format row 1 into other row to
paste the COnditional FOrmatting.
Regards,
Sebastien
"Colby" wrote:
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
|