Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
apply conditional formatting
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Apply Conditional Formatting to other rows | Excel Worksheet Functions | |||
macro to apply conditional formatting | Excel Worksheet Functions | |||
I need conditional formatting to apply to maximum % | Excel Worksheet Functions | |||
How do I apply conditional formatting? | Excel Worksheet Functions | |||
Can I Apply Conditional Formatting to a Chart? | Charts and Charting in Excel |