Report

Conditional Formatting [Solved]

Ask a question cmenzies - Last answered on Feb 27, 2017 at 03:45 PM by Mazzaropi
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!


Helpful
+0
plus moins
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.
Leave a comment
Helpful
+0
plus moins
That worked beautifully!! Thank you so much.
Leave a comment
Helpful
+0
plus moins
Thanks for the feedback.

Glad to help you.

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

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!