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.
0
That worked beautifully!! Thank you so much.
0
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
0