Add color based on validation of data between cells

I am struggling with adding a type of conditional formatting that will validate the dates within my table.
I have a cell for a date of when an item is created that is system generated from an API and then I have a billing start date that is manually entered that is prone to having transcription errors due to it being manual.

I want to enter a type of conditional formatting that would highlight, bold, color, anything if the billing start date is before the created date.

Thank you

Hi @Jeffrey_LeBlanc - you can’t do any formatting on the two date fields, but when I’m faced with these sorts of requirements, I create a new field to highlight any issues:

The Date Check field uses a formula:

IF({Billing Date} < {Created Date}, '❌❌❌❌')

If you are on a paid plan you can also use the “record colouring” feature, although, personally, I find the highlighting a bit too subtle, so still tend to go for something like the above.

JB

1 Like

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.