Filling text colour accross rows 1

[EvilTwinOfAtrus]

Hi

I have a spreadsheet where A1 is =TODAY() and column H has various dates in it. I have a conditional format set up so that if the value in column H is less than or equal to A1 (todays date) is colours the date (in column H) in red. When this cells text colour turns red, I would also like the entire row which the date is on to turn red as there is lots of info in columns A to G.

Many Thanks in advance,

- EToA

 

[cLFlaVA]

You'll have to select columns B through G and apply a Conditional Formatting formula the same way you applied the Conditional Formatting formula to the cell in column H.

*cLFlaVA
----------------------------
A pirate walks into a bar with a huge ship's steering wheel down his pants.
The bartender asks, "Are you aware that you have a steering wheel down your pants?"
The pirate replies, "Arrrrr! It's driving me nuts!

 

[sdraper]

in the conditional format for b2:g2 change the "cell value is" to "Foormula is" and enter =$A$1>$H$1 then set the format

Sam

 

[sdraper]

oops!
Foormula = Formula


Sam