\n
Hello,
\n
\n
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:
\n
If the countdown is less than 0 days, just show 0
\n
If the countdown is 3-0 days, bold in red font and highlight field yellow
\n
If the countdown is greater or equal to 4 days, no need to do any conditional formatting
\n
\n
Can you please assist me with the formula and what field type it should be?
\n
\n
I was trying to do a formula along the lines of:
\n
\n
If(ToDays([Last day]-today())<=3,\"
\n
\"<font color=red><b><div style=\\\"background-color:yellow;\\\"</div>\"&([Last day]-today()),
\n
([Last day]-today())\")
\n
\n
But I know this won't take into account the 3 different formatting and I was getting error messages related to the field type.
\n
Thank you!
\n
