Conditional formatting help

[davieja]

SOLVED. Hi all
Hopefully somebody will be able to assist me with conditional formatting
I am creating a spread sheet where I input a date that an accident form comes in cell, D3
next to it I have a simple formula that adds 7 days, E3 this is the deadline date for return of the investigation form
Is there a way to add a traffic icon or fill the cell with green for the first 3 days after D3 date, then turn to yellow from 3 days to 7 days, and finally to turn red after the 7 day deadline has passed
Many thanks in advance for any assistance you can give me

James ( aka Newbie )

[loginjmor]

Hi -

Just go to conditional formatting and add the following three separate rules using the "Use a formula to determine which cells to format" under the Select a Rule Type:

=$E$3-TODAY()>=3 Set the format to Green fill

Add another rule:

=AND($E$3-TODAY()<4,$E$3-TODAY()>=0) Set the format to Yellow fill

Add the final rule:

=$E$3-TODAY()<0 Set the format to Red fill.

Hope this helps!

[davieja]

Hi There,
Up and running
Many thanks for your help

KR
James

[loginjmor]

Great! Glad it worked! Please make sure to mark your thread as SOLVED per the instructions at the bottom of my post.