Forum Discussion

VW's avatar
VW
Qrew Trainee
2 years ago

Countdown with Conditional Formatting

Hello,   I'm trying to show a countdown of business days to an employee's last day and would like to add conditional formatting as follows: If the countdown is less than 0 days, just show 0 ...
Formulas and functions
CuongNguyen's avatar
CuongNguyen
Qrew Member
2 years ago
Use formula rich text.  You can adjust font size and bolding with this one.

If(ToDays([Last Day]-Today())<=0,"0",

If(ToDays([Last Day]-Today())<=3,
"<span style=\"color:red; font-size:110%; background-color: yellow; font-weight:bold\">" & ToText(ToDays([Last Day]-Today())) & "</span>",

ToText(ToDays([Last Day]-Today()) )))

------------------------------
Cuong Nguyen
------------------------------
  • VW's avatar
    VW
    Qrew Trainee
    2 years ago
    Hi.  Thanks, Cuong.  How about having it count business days?  How would I integrate that portion?

    ------------------------------
    V W
    ------------------------------
    • VW's avatar
      VW
      Qrew Trainee
      2 years ago
      I think I got it.  I used:

      If((WeekdaySub([Last Day],Today()))<=0,"0",

      If((WeekdaySub([Last Day],Today()))<=3,
      "<span style=\"color:red; font-size:110%; background-color: yellow; font-weight:bold\">" & ToText(WeekdaySub([Last Day],Today())) & "</span>",

      ToText(WeekdaySub([Last Day],Today()) )))

      ------------------------------
      V W
      ------------------------------
      • JulieBowers's avatar
        JulieBowers
        Qrew Member
        2 years ago
        If you figure out how to use WeekdaySub and get rid of holidays, I'd love to know. That's a current issue I'm trying to fix.

        ------------------------------
        Julie Bowers
        ------------------------------