Forum Discussion

Jna3276's avatar
Jna3276
Copper Contributor
Oct 01, 2024
Solved

Past Date Conditional Format

Hi Id like to conditional format column A to red fill if the date is 5 working days or more.   If blank then ignore or leave as is.   If it can't be done for working days, then 7 days and over i...
excel
Formulas and Functions
  • BobOrrell's avatar
    BobOrrell
    Oct 01, 2024

    Jna3276 
    This should work for you =AND(C4<=WORKDAY(TODAY(),-5),ISNUMBER(C4))

    change the 2 instances of C4 to the first cell of the range you are formatting

BobOrrell's avatar
BobOrrell
Iron Contributor
Oct 01, 2024

Jna3276 
This should work for you =AND(C4<=WORKDAY(TODAY(),-5),ISNUMBER(C4))

change the 2 instances of C4 to the first cell of the range you are formatting