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.