Forum Discussion
Conditional formatting with a complex formula
I am trying to compare two dates and then highlight the cell based on how close the two dates are. See the example below: # of days 20 Date 22-Oct 10/16/2017 10/1/2017 11/5/20...
Hi Mary,
Try to replace $A$4 with $A4
Make sure to apply conditional formatting to the range, not just single cell.