Conditional Formatting For Date Cell

Marcia Hutchinson

Hi,

 

I want to apply conditional formatting to a date cell if the date in that cell is earlier or later than a date in another cell.  Can someone tell me if this is possible and if so how to do it?  

 

Thanks.

 

-Marcia

Shaine Greenwood

Hi Marcia—There currently isn't a way to compare values in a sheet against one another to change formatting with conditional formatting rules but I'll pass your feedback along to our development team for further consideration.

 

As a potential workaround, you can create a checkbox column in your sheet and place an IF statement in it that will check the box when your one date is greater than your other date, example as follows:

 

=IF([Date Column]1 > [Other Date Column]1, 1)

 

Note that you'll need to change the column names in the formula above to the names of the date columns in your sheet.

 

You can then create a conditional formatting rule that changes the formatting if the box is checked.