# Conditional Formatting w/ Multiple Criteria involving Workday

#### klynne75

##### New Member
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>

Last edited:

### Excel Facts

Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

#### Special-K99

##### Well-known Member
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

Last edited: