MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Conditional Formatting


Posted by Steve on August 08, 2001 8:30 AM

How do I use Conditional Formatting to highlight cells that do not contain 1 of 6 values. If a cell in the column does not contain A, B, C, D, E, or F, I want it to display in red text.


Posted by lenze on August 08, 2001 8:52 AM

Use either OR or AND functions:
OR(rgn="A",Rgn="B",etc.)

Posted by Steve on August 08, 2001 9:00 AM

Thanks, but I tried that. It doesn't work.

Posted by brent on August 08, 2001 9:58 AM

Condition 1 - pick Formula Is
=A2>"f"

Posted by Steve on August 08, 2001 10:02 AM

I'm sorry, I used this as an example. The letters are not sequential

Posted by brent on August 08, 2001 10:12 AM

Try it. Start the block at the uppermost cell, if that cell is "a1" then the formula would be =a1>"f"
It worked for me - one column. I hadn't tried two or more.

Posted by lenze on August 08, 2001 10:21 AM

This seems to work for me
AND(Rgn<>"A",Rgn<>"B",etc.)

Posted by Steve on August 08, 2001 10:22 AM

If I'm looking for cells that do not include M,Q,T,A and F?

Posted by brent on August 08, 2001 11:08 AM

If I understand the parameters this time:
Forumla Is =IF(A1>"A",IF(A1<>"M",IF(A1<>"Q",AND(A1<>"T"))))

Posted by Aladin Akyurek on August 08, 2001 11:14 AM

> If I'm looking for cells that do not include M,Q,T,A and F?

Use

=NOT(OR($A1="M",$A1="q",$A1="T",$A1="A",$A1="F"))

Aladin