How to change the colour of a cell based on today's date + a few business days?

Hello,

I am a relatively new user of excel and am not really good with complex functions and formulas. But I really want to learn.

I am making me this Excel-based tracker which will help me speed-up my work a lot. It contains a lot of conditional formatting. Most of it, I somehow managed to do myself reading here and there and watching youtube videos. But there is one thing which I was not able to find anywhere (probably did not search in the right place, or was not able to understand what I was watching or reading). Here is what I’ve been struggling to do for weeks now:

I have a cell which is formatted as a date and I want this cell, when populated with a date, to be able to change its colour to green, yellow or red depending on today’s date + some business days added to today’s date. Assume that the cell in question is AN3, this is more or less the rule which I want to create for each colour:

For green: if the date in AN3 is less than (today’s date + 5 business days), then AN3 should be green
For yellow: if the date in AN3 is equal to (today’s date + 5 business days), then AN3 should be yellow
For red: if the date in AN3 is greater than (today’s date + 5 business days), then AN3 should be red.

Can anyone help me?

I registered in this forum just a few hours ago, I asked a question, and my question is answered. You guys are incredible !

Hello guys,

What if I wanted to modify the condition for two business days as follows:

For green: if the date in AN3 is less than (today’s date + 2 business days), then AN3 should be green
For yellow: if the date in AN3 is equal to (today’s date + 2 business days), then AN3 should be yellow
For red: if the date in AN3 is greater than (today’s date + 2 business days), then AN3 should be red.

@mehmetchik: Your assumption is correct. "today" will always be a weekday i.e. Monday to Friday.

Many thanks in advance

And what if I wanted to format AN3 as follows:

1.PNG

How can I do that? My problem is the part in the brackets... AN3 is always a business day (Mon thru Fri). But then I have no idea what function I should use for the '2 business days' part... I tried something like:

2.PNG

It did not work

Hello guys,

What if I have two cells e.g. AR3 and AS3.

Again, I want to apply conditional formatting (this time to AS3) as follows:

Green: if (the date in AS3) < (the date in AR3 + 10 business days)
Yellow: if (the date in AS3) = (the date in AR3 + 10 business days)
Red: if (the date in AS3) > (the date in AR3 + 10 business days)

I guess it should be something close to:

Green: AS3 < AR3+10
Yellow: AS3 = AR3+10
Red: AS3 > AR3+10

…but how do I make Excel perceive the “10” part as business days?

thank you very much Kev

Now I understand.