apply conditional formatting

[Guest]

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

 

[Guest]

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

 

[David McRitchie]

That's a little bit round about, doing the same condition twice,
once for column A then repeating for the other columns.

Select all of the columns that you want to color, you wanted to leave out G
To color all cells in columns A:G, and column H, select those columns, or
To color only the cells in A1:G1, and Cell H1, select only those cells
The cells to be colored are based on your selection.

The formula is based on your active cell which is on row 1 so

Formula1 is: =$G1 = "L" and then format as Red (font or interior)
Formula2 is: =$G1 = "W" and then format as Blue

More on conditional formatting in
http://www.mvps.org/dmcritchie/excel/condfmt.htm