Conditional Formatting

[cvdavis]

Hi there!

I am trying to conditionally format an excel spreadsheet using the "=OR" formula based on 2 conditions - =OR($H12="x", $Q12>=DATE(2019,6,1)) . I need it to ignore those conditions if cells in a certain column contain text ($E12). I cannot get this to work. I've tried adding something to the end of the string as well as a "stop if true" rule and it doesn't work.

[#2 · Accepted solution]

Try this:
=AND(NOT(ISTEXT($E12)), OR($H12="x", $Q12>=DATE(2019,6,1)))

[#3]

@JMB17 

Thank you!!! This worked perfectly :)

[#4]

You're welcome.