Forum Discussion
TRBrown
Nov 29, 2023Copper Contributor
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...
OliverScheurich
Nov 29, 2023Gold Contributor
=$H2<$I2
This 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$500
This is the range the conditional format applies to.
- TRBrownNov 29, 2023Copper ContributorIt 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.- OliverScheurichNov 29, 2023Gold Contributor
- TRBrownNov 30, 2023Copper Contributor
Here is my conditional formatting
Is it possible any of my existing is causing the error?