Excel Conditional Formatting Help Please

full-time-mum

I have a spreadsheet which lists a series of documents together with the date they were last reveiwed and the date they are due to be reviewed next.

What I'd like to do is get the entire row to turn red for those documents whose next review date is before today's date. At the moment, I haven't got as far as wanting printed reports, I just use the file on screen.
Can this be done? and If so, how?

Thanks

timnicebutdim_2

Hi I've done this before, and it's fairly simple. Click on the link and go to "conditional formatting"

http://www.mrexcel.com/archive/Dates/30810.html

Tim

full-time-mum

Many thanks - wish I hadn't done it though as it is now very obvious that practically everything needs reviewing.:eek: