Hi!

Try this:

Assume the numbers in column A are in the range A1:A50. The numbers in
column B are in the range B1:B40.

Select the range, A1:A50.
Goto FormatConditional Formatting
Formula is: =COUNTIF(B$1:B$40,A1)=0
Click the Format button
Select the style(s) desired
OK out

Biff

"petevang" wrote in
message ...

I have two columns of data (A and B) whos cells consist of only numbers
in order from 1 to 50. Columns A's ranges from 1 to 50, and every
whole number is present. Column B is missing a few numbers. I want to
see what numbers are not in column B but are in column A. Is their a
formula that could highlight the missing cells?:)


--
petevang
------------------------------------------------------------------------
petevang's Profile:
http://www.excelforum.com/member.php...o&userid=25034
View this thread: http://www.excelforum.com/showthread...hreadid=530786