Conditional Formating

H

Haiggy

Hi,

I am pulling out my hair on this one. I have a spreadsheet that is
conditionally formated on date producing 3 colours depending on formula. this
works great in one cell however I want the row to change colour if a cell in
that row = condition.

eg Cell A1 is conditionally date formated, information is in cells A2-A10 .
If A10 is "Yes" cell A1-A10 will turn grey.

Is this possible??
 
M

Marcelo

Hi Haiggy,

on the conditional format selected "the formula is" and put a10="yes"

HTH
Regards from Brazil - going to the 6th *
Marcelo

"Haiggy" escreveu:
 
Top