SOLVED

conditional formatting

Copper Contributor

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

 

AhmetHa_0-1707486638032.png

 

1 Reply
best response confirmed by AhmetHa (Copper Contributor)
Solution

@AhmetHa 

Use

 

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

1 best response

Accepted Solutions
best response confirmed by AhmetHa (Copper Contributor)
Solution

@AhmetHa 

Use

 

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

View solution in original post