Conditional Formatting

  • Thread starter Thread starter kelleyz3
  • Start date Start date
K

kelleyz3

How would I set it up where a data in a cell would be red unless it wa
equal to N, O or P
 
Hi
use the following formula in the conditional format dialog:
=AND(A1<>"N",A1<>"O",A1<>"P")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting 1
Conditional Formatting Help 3
Scrabble Value calculation for Welsh words 0
Changing cell colors from a function command 3
Conditional Formatting 1
Is there a function to solve for an unknown in an equation? 9
Conditional Formatting for cells with formulas 1
Conditional Formatting Driving Me Crazy 1

Back
Top