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??
--
You have to throw a stone to make the pond ripple