Conditional formatting based on number of days

[lre712]

Hi everyone

I am after some help with conditional formatting, I am creating an activity tracker. What I want to do is change the colour of the end date cell if it is within 5 work days or less of today's date.

I have the end date in A2:A3 etc.

Cheers
Lee

 

[Peter Bartholomew]

Format cells that contain a value of 'less than or equal to'
= TODAY() + 5

 

[lre712]

Thanks for the reply Peter.

When I try the above everything turns red.I have the following end dates 3-Dec - 17 Dec.

I also would like it to skip any weekend if possible,

 

[Peter Bartholomew]

Then you need a custom formula along the lines of
= NETWORKDAYS( TODAY(), +dueDate ) <= 5
I will take a look tomorrow if no one else has chipped in by then.

 

[pecoflyer]

You can also use the NETWORKDAY.INTL function which allows to choose weekends falling on other days then Sa-Su
https://support.office.com/en-us/ar...function-a9b26239-4f20-46a1-9ab8-4e925bfd5e28

 

[Khalid NGO]

Hi Lee,
Good day...

You can get more targeted answers by uploading a sample version of your file with manually expected output.

Regards,