Conditional Formatting from current date

[ExcelRoy]

Hi,

I am looking for a way to notify me of any date that exceeds todays date by 2 days

If at all possible I would like week days only, but not sure if this is too complicated

Many thanks

 

[ExcelRoy]

yes my confusion, sorry all works great now, thanks

 

[ExcelRoy]

Hi Guys,

First may I apologize for my own confusion last night

=AND(A3-TODAY()<2,WEEKDAY(A3,2)<6) works almost as I need it to but this will highlight (today 08/11/17 and 06/11/17 of which I would like to not be highlighted)

I need anything under 2 days of today() highlighted only

oh and if possible no blanks are to be highlighted

Many thanks and apologies once again

 

[Scott T]

Try

=AND(TODAY()-A3>2,WEEKDAY(A3,2)<6)

 

[ExcelRoy]

Boom!

Awesome, that's perfect, many thanks Scott T

 

[Scott T]

We are glad to help.