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
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?