Conditional Formatting

[ExcelRoy]

Hi all,

I am looking to add a warning light on my data to show which rows of data when it will be nearing the expected dates

I would like an yellow indicator if it is within 5 days of the delivery date, orange within 3 days, green within 1 day and red if it goes over the delivery date

I have a delivery date in L10 and M" has the =now() for todays date

Any help many thanks

 

[mattmickle]

I would change your =now() to =today() otherwise you're fooling around with timey wimey stuff.
Select the column of dates you want to format
In your conditional formatting window, choose the 2nd option (Format only cells that contain)
you'll set up 4 conditionals:

If Cell Value > $L$10, format RED
If Cell Value between $L$10-1 and $L$10, format GREEN
If Cell Value between $L$10-3 and $L$10-2, format ORANGE
If Cell Value between $L$10-5 and $L$10-4, format YELLOW