scoobz1234
New Member
- Joined
- Jun 19, 2013
- Messages
- 2
Good Morning,
I am trying to create 3 formulas to check column M for conditions.
condition 1 is BLANK and C4 is LESS than TODAY(). highlight RED
condition 2 is "Routed" highlight YELLOW
condition 3 is "Filed/Complete" highlight GREEN
i tried
<TODAY()),"")<TODAY()),)<TODAY()),"")<TODAY()),"") doesnt this but html work.<>
I am trying to create 3 formulas to check column M for conditions.
condition 1 is BLANK and C4 is LESS than TODAY(). highlight RED
condition 2 is "Routed" highlight YELLOW
condition 3 is "Filed/Complete" highlight GREEN
i tried
Code:
=IF(AND(M4=BLANK, C4<TODAY()),"")
Last edited: