conditional formating between sheets

Hi,

Assign the cell on Sheet B as a named range, and then use the named range in the conditional formatting formula.

... or upgrade to Excel 2010. I love it! No more named ranges just for data validation or CF.

Your formula is missing a closing parens

=ISNUMBER(MATCH(sheet1value, sheet2value,0))

where sheet1value is a named range in sheet1 and sheet2value is a named range in sheet2

cheers

You could also use

=sheet1value=sheet2value

that saves you the whole Isnumber and Match broohaha.

Assuming you don't just want to compare one cell, but each cell of the table with the respective cell of the table in the other sheet, you will need a helper table.

The formula in the helper table is

=B5=B!C7

copied across and down.

Now, select your whole table in sheet A and enter this formula for conditional formatting:

=H5=FALSE

Assign the format of your choice and hit OK

Now each cell in the table will turn red if its respective counterpart in sheet B is not the same value. You can hide the columns with the helper table, if it mucks up your spreadsheet design.

Note that there are no $ signs in the cell reference.

see attached.

cheers