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.