Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Row Color using VBA
I have to admit that I'm no excel expert. I have been playing around with
VBA trying to format the color of a row. I use conditional formatting on cell C1. If C1=Y then I turn it green. If C1=N then I turn it red. I would like to know how to turn either the entire row a or a range (A1:A2) within that row to follow the format of cell C1. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Row Color using VBA
you could select a1 & a2, then choose conditional formatting
select formula is from the dropdown and then pastes this in the box =$C$1="Y" then format the cells however you want post back if i'm off base here. -- Gary Excel 2003 "HomeStarRunner" wrote in message ... I have to admit that I'm no excel expert. I have been playing around with VBA trying to format the color of a row. I use conditional formatting on cell C1. If C1=Y then I turn it green. If C1=N then I turn it red. I would like to know how to turn either the entire row a or a range (A1:A2) within that row to follow the format of cell C1. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Row Color using VBA
Thanks Gary, that looks good. Now I try to copy the cell format of A1 and B1
to A2:B2. For example, I want A2:B2 to follow the same formatting if C2 is changed to Y or N. I can't copy the formatting to A2:B2 as it keeps the same conditional formatting to cell C1 where it needs to reference C2. Please help if you are able. --Thanks "Gary Keramidas" wrote: you could select a1 & a2, then choose conditional formatting select formula is from the dropdown and then pastes this in the box =$C$1="Y" then format the cells however you want post back if i'm off base here. -- Gary Excel 2003 "HomeStarRunner" wrote in message ... I have to admit that I'm no excel expert. I have been playing around with VBA trying to format the color of a row. I use conditional formatting on cell C1. If C1=Y then I turn it green. If C1=N then I turn it red. I would like to know how to turn either the entire row a or a range (A1:A2) within that row to follow the format of cell C1. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Row Color using VBA
you'll need to remove the absolute reference to the row. use this in the
formula, then you'll be able to copy the format down the column. after you do, just reopen the conditional formatting dialog and look at the formula. the row number should change. in my original post, the row number would not have changed and it would have referenced C1. =$C1="Y" -- Gary "HomeStarRunner" wrote in message ... Thanks Gary, that looks good. Now I try to copy the cell format of A1 and B1 to A2:B2. For example, I want A2:B2 to follow the same formatting if C2 is changed to Y or N. I can't copy the formatting to A2:B2 as it keeps the same conditional formatting to cell C1 where it needs to reference C2. Please help if you are able. --Thanks "Gary Keramidas" wrote: you could select a1 & a2, then choose conditional formatting select formula is from the dropdown and then pastes this in the box =$C$1="Y" then format the cells however you want post back if i'm off base here. -- Gary Excel 2003 "HomeStarRunner" wrote in message ... I have to admit that I'm no excel expert. I have been playing around with VBA trying to format the color of a row. I use conditional formatting on cell C1. If C1=Y then I turn it green. If C1=N then I turn it red. I would like to know how to turn either the entire row a or a range (A1:A2) within that row to follow the format of cell C1. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checkbox to change background color, font color and remove/ add bo | Excel Discussion (Misc queries) | |||
how can I conditionally change font color, or background color? | Excel Worksheet Functions | |||
change fill color of a range of cells based on color of a cell? | Excel Programming | |||
How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
Browse Forms Controls and change TextBox color based on cell color | Excel Programming |