Forum Discussion

AhmetHa's avatar
AhmetHa
Copper Contributor
Feb 09, 2024
Solved

conditional formatting

Hi want to format so if, closed by dosent include a Yes and todays date has gone past the date in h9 I want it to turn red I know how to set the colour just don't know the formula    
  • HansVogelaar's avatar
    Feb 09, 2024

    AhmetHa 

    Use

     

    =AND($H9<>"", $H9<TODAY(), $K9<>"Yes")