Conditional Formatting [Solved/Closed]

Report
-
Posts
1888
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
March 1, 2021
-
I am trying to format column 'O' if the value is greater than zero but where column 'P' does not include "SBNAS735" or "SBTDP443". Help!


3 replies

Posts
1888
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
March 1, 2021
142
cmenzies, Good afternoon.

Try to use:

=AND(O1>0, P1<>"SBNAS735", P1<>"SBTDP443")

Please, tell us if it worked for you.
I hope it helps.
That worked beautifully!! Thank you so much.
Posts
1888
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
March 1, 2021
142
Thanks for the feedback.

Glad to help you.

Have a nice week!
--
Belo Horizonte, Brasil.
Marcílio Lobão

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!