Hi there,

This probably is really simple but basically what I want to do is b
able to quickly search a spreadsheet to see if people have made manua
adjustments.

Basically, we often download stuff from other databases into excel, s
most of the cells will be populated with stuff like:

=kfcell(B3,B4,B5.....B8)

one complication is that since these numbers are often huge, they ar
usually divided by either 1000000 or 1000000000.

what I want to do is find all cells that have + or - adjustments i
them, for example, find:

=kfcell(B3,B4,B5.....B8)/1000000+3.1

or

=kfcell(B3,B4,B5.....B8)/1000000000-13.4

but ignore

=kfcell(B3,B4,B5.....B8)/1000000

I am also still not sure about the best way to return those values.
think that, ideally, I would like there to be an option box for th
user to choose whether to have a list of affected cells or to highligh
the affected cells or both.

I figure it's probably going to have to be a macro but I have no ide
how to use forms.

Can anyone hel

--
Message posted from http://www.ExcelForum.com