Need help with conditional formatting

taytaytodd

HI, I want to make a conditional formatting rule for IF "ETA" is greater then "TARGET RECEIVE BY DATE", then highlight yellow. The current columns are formatted for TEXT/NUMBER. Not sure if they need to be in DATE format within column properties.

AravindGP

Hi @taytaytodd

There isn't a way to compare two columns in Conditional Formatting settings. If you intend to compare the dates in ETA and Target Receive by Date, it is better to have both of those columns in Date format and have a helper column added which has the formula =IF(ETA@row > [Target Receive by Date]@row, "Yes", "No"). This formula will populate your helper column with a Yes when ETA is greater. You can then use the helper column in your Conditional Formatting settings to look for Yes and highlight the row or particular cells in Yellow.