Hi, I came with a formula to count 30 days out from the date in the column next to it, now I'm trying to expand on that to have it turn red if it gets to be 10 days or less to the due date. I'm running excel 365 so I don't believe I have access to the Conditional Formatting feature? as an example
A1 A2
12/14/16 1/13/17
when it gets to be 1/3/17 I want A2 to automatically turn red.
The formula I'm working off of is =IF(F3="","",(F3+30)) if that helps??
Thanks everyone!
A1 A2
12/14/16 1/13/17
when it gets to be 1/3/17 I want A2 to automatically turn red.
The formula I'm working off of is =IF(F3="","",(F3+30)) if that helps??
Thanks everyone!