Conditional Formatting w/ Multiple Criteria involving Workday

[klynne75]

I'm using Excel 2013. I have a column of "Closing Dates". I need anything in that column dated today to highlight in red, 3 days in the future highlighted in green, and 5 days in the future highlighted in yellow (anything older than today has no highlighting).


The RED formatting is easy =$F4=TODAY()...stop if true

...after that, I'm lost. Here's a few things I've tried...(formula variations were consistent for each attempt)

GREEN =$F4=WORKDAY(TODAY(),3)...stop if true
YELLOW =$F4=WORKDAY(TODAY(),5)...stop if true

GREEN =($F4=(WORKDAY($F4,+3)))...stop if true
YELLOW =($F4=(WORKDAY($F4,+5)))...stop if true

I've also tried DATEDIF and AND formulas...but I'm guessing my formulas are wrong

Any help or direction to a different thread (I have looked and tried to make some work) are appreciated.



<tbody>
</tbody>

 

[Special-K99]

These look fine to me

GREEN =$F4=WORKDAY(TODAY(),3)...stop if true
YELLOW =$F4=WORKDAY(TODAY(),5)...stop if true

This will highlight only when F4 is three/five working days ahead (not within three/five working days)

Maybe your dates aren't really dates even though they look like dates?

in a blank column in row 4 put =ISNUMBER(F4)
and copy down the column to test if they are actually proper dates