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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"sebastienm" wrote in message ...
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