Conditional Formatting w/ Multiple Criteria involving Workday

klynne75

New Member
Joined
Dec 11, 2009
Messages
17
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:

Some videos you may like

Excel Facts

Excel Can Read to You
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
Joined
Nov 7, 2006
Messages
8,341
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:

Watch MrExcel Video

Forum statistics

Threads
1,089,970
Messages
5,411,577
Members
403,380
Latest member
ifog671

This Week's Hot Topics

Top