conditional formating excel

[Ace Modder]

I have a spreadhseet with a list of orders, and the delivery dates on them.

I have set the conditional formatting to "Cell" "equal to" "=TODAY()" to show the order in red.

I have set the conditional formatting to "Cell" "equal to" "=TODAY()+1" to show the order in orange.

I have set the conditional formatting to "Cell" "equal to" "=TODAY()" to show the order in green.

I need to set the conditional formatting to only inclde weekdays....

NOT WEEKENDS DAYS. so on Monday show friday as orange, and thursday as red

Any ideas how?

 

[Ace Modder]

I may not have explained myself very good.

What I need is.

We deliver on Monday - Friday. We have to pick the goods 2 working days before.

So I want to open the spreadsheet on Monday and have all of Wednesdays del dates in red, Tuesdays del dates in orange, and mondays del dates in Green. which is fine using the conditional formatting.

But when it comes to Thursday, I want it to find all of Mondays del dates in red, and Fridays dates in orange and thursdays in green.

On Friday I want all on Tuesdays del dates in red, mondays i want orange and fridays i want in green.

Thats the problem I have.

I have tried to use "=TODAY()+2WORKDAY" But that does not work.

 

[Ace Modder]

Well that's okay - just change the IF statements to check how many working days in advance. My example just checks for 0days (red), 1 days (orange) and >1days (green).

You might need an extra IF that finds the next working day rather than just the next day.. This will deal with weekends.

Not that hard!!

and how do I do that?