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.