Hi Danny

numbers formatted to hide the decimal places aren't actually rounded they
just look that way
try this
type in A1
57.6
and format it to show no decimal places now in B1 type
=A1*100
you will see that the original number is multiplied by 100 not the formatted
number

to round a number use the round function
=ROUND(A1,0)

unfortunately, i can't think of an easy way to solve your problem unless you
use tools / options / calculation, precision as displayed ... however, the
following warning is given in HELP
--
Caution When you change the precision of the calculations in a workbook by
using the displayed (formatted) values, Excel permanently changes any
constant values on the worksheets in the workbook. If you later choose to
calculate with full precision, the original underlying values cannot be
restored.
---
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Danny" wrote in message
...
I have cells in a worksheet that brings in numbers (linked to the cell)from
other sheets in the work book. The values being brought in a simple
numbers,
averaged from a small set of other numbers.

All number formats are set to number, 0 decimal points.

The roll up table is showing the correct, rounded values to the nearest
whole number that are linked back to cells in the supporting work sheet.

However, the problem appears to be that conditonal formating is looking at
the worsheet values and applying the format to the un rounded values.

For example, if I tell the roll up table to format red each cell that has
a
value between 3 & 3.99. The table shows side by side cells that both
contain
the number 3. However one cell is red and the other is not. If you go
back
to the cell of origin for each, it will show that the unrounded value for
one
cell may be 2.8, and 3.5 for the other. The condition is applied based on
the decimal points, even though the origin cells are fomatted with no
decimal
places.

Thanks in advance,

Danny