Forum Discussion
How do I format column I to highlight based on the value in column H
I'm working on a tracking sheet where Column H (2-500) is the due date and Column I (2-500) is the date actually complete. I want to conditionally format it where if the date it was complete is any t...
=$H2<$I2This rule for conditional formatting works in my example. Perhaps you can compare the screenshot with your data and see if there is a difference.
=$H$2:$I$500This is the range the conditional format applies to.
It still isn't working for me yet, could my issue be that column H is populated by a formula to auto fill the date based on column B?
The formula being "=IF(B2="","",TEXT(WORKDAY.INTL(B2,3,"0000011"),"m/dd/yyyy"))"
Unfortunately, the sheet I'm using has PII and I can't share it as is.
The formula being "=IF(B2="","",TEXT(WORKDAY.INTL(B2,3,"0000011"),"m/dd/yyyy"))"
Unfortunately, the sheet I'm using has PII and I can't share it as is.
Here is my conditional formatting
Is it possible any of my existing is causing the error?
The dates in column H (sent by) are actually text. The dates in column H are left-aligned which is a visual indication that they are text. You can change the format of column H to date. The dates in column I are formatted as dates. This can be seen in the screenshot because they are right-aligned.
The rule for conditional formatting in your sheet is =$H$2<$I$2. This rule only checks if I2 is greater than H2. It doesn't check the rows below row 2. For the applies to range =$I$2:$I$500 you can either use the rule =$H2<$I2 or the rule =H2<I2.
It isn't possible that any of the other rules causes a problem with this rule because =H2<I2 has the first priority in your sheet. Above the rules it says "Rule (applied in order shown)" and =H2<I2 is the first priority.