Conditional Formatting for cells with no data and dates that have passed.

[krispartsbadger]

I'm looking for a conditional format for Column R. I'm looking to fill the cells Red, that would be considered late and have no Updated Ship Date. The desired outcome would be pictured below. Thanks!

 

[SanjayGMusafir]

Check this and revert - Use the formula below to CF

=And($Q1<Today(),R1="")

 

[krispartsbadger]

Amazing!! Thank you, is there a way to add to that formula that it would also only show red if there was data to the column to the left. I tried figuring this out with the formula you shared with me yesterday, but I was unable to figure it out.

 

[SanjayGMusafir]

Check this and revert -

=And($Q1<Today(),R1="",$Q1<>"")

 

[SanjayGMusafir]

Check this and revert -

=And($Q1<Today(),R1="",$Q1<>"")

@krispartsbadger Were you able to try the above? Did it work for you?

 

[krispartsbadger]

Amazing! Thank you so much!

 

[SanjayGMusafir]

Glad to help you and thanks for the feedback.