Conditional Formatting

Solved/Closed
cmenzies - Feb 27, 2017 at 12:07 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - 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!


3 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Feb 27, 2017 at 02:00 PM
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.
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Feb 27, 2017 at 03:45 PM
Thanks for the feedback.

Glad to help you.

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