Change Row Color using VBA

[HomeStarRunner]

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.

 

[Gary Keramidas]

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.

 

[HomeStarRunner]

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]

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"