Excel 2007 : Conditional Formatting Help

[Martin_R]

Image.png

I have attached a screen shot of a selection of the data I am working with.
I need to be able to highlight the whole row in red should any date in column K be 3 months or older than today.

The rather basic way I did this so far was to add another column with =K1+90 to give me a due date.
Then I added some conditional formatting along the lines of =$L$2<TODAY() and format the cell with a red fill.

This will only highlight one cell red and I have to do formatting for each cell (?).

Does anybody have a simpler way of doing this?

Many thanks.

[Bob Phillips]

See http://www.xldynamic.com/source/xld.CF.html#due