Conditional Formating

[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??

 

[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:

 

[Haiggy]

Sweet , thanks man hope Brazil go on to win but watch the Argies they look hot.

 

[Marcelo]

thanks for the feedback.


"Haiggy" escreveu:

Sweet , thanks man hope Brazil go on to win but watch the Argies they look hot.