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

Galaxy Note 8 vs iPhone X

Awful clip art from 1994 is being tweeted every hour by a bot

iPhone X vs Samsung Galaxy Note 8

Les meilleurs navigateurs internet 2017