MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formula


Posted by Lars on September 12, 2001 2:04 PM

How do I get a formula to make a cell a certain color if it doesn't match another cell. For example -
This is sample of some of the data I have
Column N Column S
PHX PHX
FSD PHX
DEN DEN
IAD DEN

How do I write a formula that says if Column S is not equal to Column N than make Column S red. I have a formula in column S already it is =if(iserror(vlookup($A3,dec01,14,0)),"",vlookup($A3,dec01,14,0))
I'm not sure how to do it with conditional formatting?


Thanks


Posted by Aladin Akyurek on September 12, 2001 2:30 PM

Select the range in S.
Activate Format|Conditional Formatting.
Select "Formula Is" for Condition 1.
Enter as formula:

=S1<>N1

Thus: no $-sign around the cell specs. I assumed that the first value is in row 1 (whence N1 and S1). Adjust this to your situation.

Activate Format button.
Select the desired color on Patterns tab.
Click OK.

Aladin

Posted by Lars on September 12, 2001 3:23 PM

Thanks Aladin