Conditional Formatting - Overdue dates

[Jayne125]

Hi All,

I'm a newbie here but have fairly basic excel skills. I would be very grateful for any help.

I have a spreadsheet which contains a column with the date a piece of work was received and a column with the due date. I am trying to highlight when a piece of work is due in 5 days then 2 days and then is overdue. I have tried various methods but just cant get it to work properly.

I've tried entering =TODAY() into a cell within the sheet and using this in conditional formatting using (format only cells that contain: cell value: less than or equal to, then added the cell with =TODAY() included +2 and +5) This didn't seem to work

I've also tried entering =TODAY() into a cell within the sheet and using this in conditional formatting using (format only cells that contain: cell value: Less than, then added the cell with =TODAY() included +2 and +5)

Any help would be greatly appreciated!

Thanks
Jayne

 

[Trevor G]

Hi Jayne,

It is about the order within the Conditional formatting that will work for you. Take a look at this image.

 

[Jayne125]

Hi Trevor,

Thank you so much for your help. I've followed your rules in the image and attached what I've done but it's still not looking right?

Any ideas?

Thanks
Jayne

 

[Trevor G]

Hi Jayne,

In the image you are sharing you have selected the whole column, it should be just the range.