I have a problem on conditional formatting with date and time.
I have a cell A1
that has date and time and I want to conditionally format its adjacent cell if the value of cell A1
is greater than 3 days compared to today. Cell A2
should show as "Follow-up Required" and cell colour should turn red. If cell value of A1
is less than 3 days compared to today, no action is required.