Cell color change referencing the date in designated cell

[Klonja]

HI,

How can I have fill color of cell change according to due date. In
example, red overdue, green - on time, black complete.

Thanks, K

 

[Trevor Shuttleworth]

Use Conditional Formatting. You'll need to determine what is Overdue,
On-time and Complete

Read up on the help and come back for specific help

Regards

Trevor

 

[Frank Kabel]

Hi Clonja

if you have a column with your due status select the cell and goto
'Format - Conditional format'. Select your condition(s) and the
formats. For more information have a look at
http://www.contextures.com/xlCondFormat01.html
http://www.cpearson.com/excel/cformatting.htm

HTH
Frank

 

[Andrew]

Please specify what you mean by overdue, on time and complete.

If overdue means it should have been paid by yesterday and on time
means today you can use these formulas for Conditional Formatting.

Assuming the date is shown in A1,

Overdue
=IF(A1<TODAY(),TRUE,FALSE)

On time
=IF(A1=TODAY(),TRUE,FALSE)