Conditional Formatting [Solved/Closed]

cmenzies - Feb 27, 2017 at 12:07 PM - Latest reply: Mazzaropi 1826 Posts Monday August 16, 2010Registration dateContributorStatus April 15, 2018 Last seen
- Feb 27, 2017 at 03:45 PM
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!


See more 

3 replies

Mazzaropi 1826 Posts Monday August 16, 2010Registration dateContributorStatus April 15, 2018 Last seen - Feb 27, 2017 at 02:00 PM
0
Helpful
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.
0
Helpful
That worked beautifully!! Thank you so much.
Mazzaropi 1826 Posts Monday August 16, 2010Registration dateContributorStatus April 15, 2018 Last seen - Feb 27, 2017 at 03:45 PM
0
Helpful
Thanks for the feedback.

Glad to help you.

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