Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
I want to change the colour of cells A1:G1 if the value of G1 is K (make the
row green), U (make the row amber) or S (make the row red). Really want this to apply to each row below as the relevant G value is input. Does that make sense? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
Highlight A - G.
Conditional Formatting... Pick: Formula Is enter: =$G1="K" Format, pick your fonts. Same for the others. The key is to retain the $ before the G. "Philip Drury" wrote: I want to change the colour of cells A1:G1 if the value of G1 is K (make the row green), U (make the row amber) or S (make the row red). Really want this to apply to each row below as the relevant G value is input. Does that make sense? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
Hello,
My sheet is 10.000 row so It's possible to do this operation manually. Is it possible to copy first row property to all rows? Regards, "Sean Timmons" wrote: Highlight A - G. Conditional Formatting... Pick: Formula Is enter: =$G1="K" Format, pick your fonts. Same for the others. The key is to retain the $ before the G. "Philip Drury" wrote: I want to change the colour of cells A1:G1 if the value of G1 is K (make the row green), U (make the row amber) or S (make the row red). Really want this to apply to each row below as the relevant G value is input. Does that make sense? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
Pre-select the 10000 rows then add the formatting using Formula is:
Pre-select can be done by entering A1:G10000 in NameBox and hit ENTER Note carefully where you place the $ signs. Or Format row 1 then use the format painter to paint the rest of the rows. Gord Dibben MS Excel MVP On Fri, 19 Jun 2009 04:17:01 -0700, Ozgur Bilgin wrote: Hello, My sheet is 10.000 row so It's possible to do this operation manually. Is it possible to copy first row property to all rows? Regards, "Sean Timmons" wrote: Highlight A - G. Conditional Formatting... Pick: Formula Is enter: =$G1="K" Format, pick your fonts. Same for the others. The key is to retain the $ before the G. "Philip Drury" wrote: I want to change the colour of cells A1:G1 if the value of G1 is K (make the row green), U (make the row amber) or S (make the row red). Really want this to apply to each row below as the relevant G value is input. Does that make sense? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |