matching two cells

[cadamhill]

If two seperate cells match, everything is ok. If two cells do not match, i want to show a predetermined message.

Example, if the bidder of a job is local (based on the state) and there is a local bidder preference, then the cell will highlight green. If the bid is not local, I want flag that cell red and respond by saying, "Bidder not local!" in a separate column off to the side. Would someone be so kind as to lend me a hand. Thanks in advance!

[samurusawyer]

Use Excel to compare two lists of data

1. Select column B (click the letter B)
2. Choose Format > Conditional formatting
" 3. In ""Condition 1"" choose ""Formula is"""
" 4. Enter this formula =(COUNTIF($A:$A,B1)=0)*(B1<>"")"
" 5. Click the ""Formats"" button and take your pick. OK.OK."