Amandle -
Are the values supposed to correspond to each other in the same row or can
one value be anywhere in the column?

If you just want to check if, for example, a value in B10 matches to A10 you
can use a simple IF() function:

=IF(A10=B10,"these values match","don't match")

If you want to see if, for example, B10 matches ANY value in column A use
the MATCH() function nested in an IF() statement:

=IF(ISNUMBER(MATCH(B10,A1:A1000)),"match found","no match found")
--
Regards,

DavidB


"Amandle" wrote:

I am trying to figure out what to do...
I have an excel spreadsheet with a lot of figures on it. One of the figures
has to match another and becomes quite time consuming when I have to go down
the entire list to make sure the numbers match. Is there a formula that I can
insert to make either the font color different if the numbers do not match?
Or does anyone have a suggestion?Thanks for your help