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
