Excel - Conditional Formatting

  Dirty Dick 20:13 07 Feb 2010


I am trying to make a spreadsheet where payments are recorded, and if overdue then use Conditional Formatting to colour the cell in red. The sheet is monthly, with dates running across the top (columns) and names running down the rows. I am getting rather confused in the depths of Conditional Formatting !!

I am running Excel 2007, and Windows 7

Any help appreciated,



  scotty 09:32 08 Feb 2010

Have a read of this thread, it might point you in the right direction.

  Dirty Dick 09:37 08 Feb 2010

Thanx scotty, but there don't seem to be a link !!

  scotty 12:07 08 Feb 2010


click here

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone