compare two colunms and bold different cells (2000)

Topic

New Reply

I have two colunms of data. and want to compare them so that the cells in first colunm containing different number than the second colunm will be formated “bold”. any idea for the codes ?
thank you very much

Reply | Quote

Replies

Do you want to bold a cell if it is different from the corresponding cell in the second column, or do you want it bold if it is different from all of the cells in the second column? For example, in the following, which cells should be bold:

   A    B
1  1    2
2  1    1
3  2    1
4  3    4
5  4    5

Reply | Quote

cells in column b are all unique number.
I want it bold if it is different from all of the cells in the second column.
thank you
Joe Xie

Reply | Quote

Select the column which will have bolded those values which do not appear in the second column. I’ll assume this is column A and the second column being compared against is column B, and the first cell in the first column is A1. Select Format,Conditional. In the dialog box showing “Cell Value Is”, click the drop down and select Formula Is, then in the formula box enter =NOT(COUNTIF(B:B,A1)), then click Format, Font tab, Bold, OK, OK.

Reply | Quote

You can use conditional formatting to do this. If the “unique number” are in column B, and the numbers you want to bold are in column A, then do the following:

1- Select Column A.

2- Select “Conditional Formatting…” from the Format menu.

3- In the dialog box, select “Formula is” in the drop down list on the left.

4- Enter the formula below into the Formula Text Box:

=ISERROR(VLOOKUP(A1,$B:$B,1,FALSE))

5- Click on the Format button.

6- Click on Bold under Font style.

7- Click on OK twice.

Reply | Quote

It works like a charm.
thank you all for the help.

Reply | Quote