SOLVED

Conditional Formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-1519948%22%20slang%3D%22en-US%22%3EConditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1519948%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20conditionally%20format%20an%20excel%20spreadsheet%20using%20the%20%22%3DOR%22%20formula%20based%20on%202%20conditions%20-%26nbsp%3B%3DOR(%24H12%3D%22x%22%2C%20%24Q12%26gt%3B%3DDATE(2019%2C6%2C1))%20.%20I%20need%20it%20to%20ignore%20those%20conditions%20if%20cells%20in%20a%20certain%20column%20contain%20text%20(%24E12).%20I%20cannot%20get%20this%20to%20work.%20I've%20tried%20adding%20something%20to%20the%20end%20of%20the%20string%20as%20well%20as%20a%20%22stop%20if%20true%22%20rule%20and%20it%20doesn't%20work.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1519948%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1519952%22%20slang%3D%22es-ES%22%3ERE%3A%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1519952%22%20slang%3D%22es-ES%22%3E%3CA%20href%3D%22Https%3A%2F%2FMarketWatch.api.com%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EHttps%3A%2F%2FMarketWatch.api.com%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1519953%22%20slang%3D%22es-ES%22%3ERE%3A%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1519953%22%20slang%3D%22es-ES%22%3E%3CA%20href%3D%22http%3A%2F%2Fwww.hsbc.lili.microsoftrewards.btc.apu%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ewww.hsbc.lili.microsoftrewards.btc.apu%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1520377%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1520377%22%20slang%3D%22en-US%22%3ETry%20this%3A%3CBR%20%2F%3E%3DAND(NOT(ISTEXT(%24E12))%2C%20OR(%24H12%3D%22x%22%2C%20%24Q12%26gt%3B%3DDATE(2019%2C6%2C1)))%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1520929%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1520929%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F675152%22%20target%3D%22_blank%22%3E%40JMB17%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!!!%20This%20worked%20perfectly%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1521053%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1521053%22%20slang%3D%22en-US%22%3EYou're%20welcome.%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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.

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

@JMB17 

Thank you!!! This worked perfectly

Highlighted
You're welcome.