Forum Discussion

TRBrown's avatar
TRBrown
Copper Contributor
Nov 29, 2023

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 time after the due date it highlights red. 

 

I've tried most routes I can think of and haven't been able to find a good answer, anytime I do "=H2<I2" nothing changes in the sheet. What am I missing?

excel
Formulas and Functions
office 365
  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Nov 29, 2023

    TRBrown 

    =$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.

    • TRBrown's avatar
      TRBrown
      Copper Contributor
      Nov 29, 2023
      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.

Resources