Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto fill color of row
I have conditional formating & color in a cell, but I want to color the
entire row of conditional formating cell. Is there any option to do it ? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto fill color of row
Hi,
You could use the formula is option in your conditional format.. Maybe.. Select your row and use this conditional format.. In the example below I have selected a range of cells. Formula isEqual to=A1=1 This will change the format of my selected row if cell A1 = 1... Hope this helps, Gav "capital letter" wrote: I have conditional formating & color in a cell, but I want to color the entire row of conditional formating cell. Is there any option to do it ? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto fill color of row
I guess that Gav may have intended to say =$A1=1, as the absolute addressing
ensures that the A1 formula is applied to all the selected cells. If you select the range and insert the formula using A1 instead of $A1, then it would look for B1 being 1 to shade cell B1, and so on, instead of shading all of them if A1=1, which is what I thought was required? -- David Biddulph "Gav123" wrote in message ... Hi, You could use the formula is option in your conditional format.. Maybe.. Select your row and use this conditional format.. In the example below I have selected a range of cells. Formula isEqual to=A1=1 This will change the format of my selected row if cell A1 = 1... Hope this helps, Gav "capital letter" wrote: I have conditional formating & color in a cell, but I want to color the entire row of conditional formating cell. Is there any option to do it ? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto fill color of row
David,
Thanks for pointing that out it was a small typo on my part.. Gav. "David Biddulph" wrote: I guess that Gav may have intended to say =$A1=1, as the absolute addressing ensures that the A1 formula is applied to all the selected cells. If you select the range and insert the formula using A1 instead of $A1, then it would look for B1 being 1 to shade cell B1, and so on, instead of shading all of them if A1=1, which is what I thought was required? -- David Biddulph "Gav123" wrote in message ... Hi, You could use the formula is option in your conditional format.. Maybe.. Select your row and use this conditional format.. In the example below I have selected a range of cells. Formula isEqual to=A1=1 This will change the format of my selected row if cell A1 = 1... Hope this helps, Gav "capital letter" wrote: I have conditional formating & color in a cell, but I want to color the entire row of conditional formating cell. Is there any option to do it ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto fill color of row | Excel Worksheet Functions | |||
Auto-populate, Auto-copy or Auto-fill? | Excel Worksheet Functions | |||
auto color fill cells | New Users to Excel | |||
Auto fill color change | Excel Discussion (Misc queries) | |||
Formatting cells Auto fill color using €œIf€ | Excel Worksheet Functions |