Comparing data sets with +/-1 tolerance using conditional formatin
 

Please help! This has been puzzling me for hours!!

I am using conditional formating to compare one data set with another to see
if there are any discrepancies, using green cells for the same and red cells
for different data.

However, one set of data is rounded to the whole number, but the other set
is to 2 decimal places (and has to remain that way). Therefore I need my
conditional formating to compare the two data sets, but with a tolerance of
plus or minus 1.00. How do I create this formula using conditional formating?

Comparing data sets with +/-1 tolerance using conditional formatin
 

CF/ Formula is: =ABS(A1-B1)<=1
--
David Biddulph


"ExcelHasMeBeat" wrote in message
...
Please help! This has been puzzling me for hours!!

I am using conditional formating to compare one data set with another to
see
if there are any discrepancies, using green cells for the same and red
cells
for different data.

However, one set of data is rounded to the whole number, but the other set
is to 2 decimal places (and has to remain that way). Therefore I need my
conditional formating to compare the two data sets, but with a tolerance
of
plus or minus 1.00. How do I create this formula using conditional
formating?

Comparing data sets with +/-1 tolerance using conditionalformatin
 

Suppose one data set is in column A and the other in column D.
Highlight the cells in column A, with A1 as the active cell, and then
bring up the conditional formatting dialogue box. Choose Formula Is in
the first box, and enter this formula:

=ROUND(A1,0)=ROUND(D1,0)

Then click on the Format button, Patterns tab and chose green, then OK
(twice) to exit the dialogue box.

Hope this helps.

Pete

On Nov 25, 3:54*pm, ExcelHasMeBeat
wrote:
Please help! This has been puzzling me for hours!!

I am using conditional formating to compare one data set with another to see
if there are any discrepancies, using green cells for the same and red cells
for different data.

However, one set of data is rounded to the whole number, but the other set
is to 2 decimal places (and has to remain that way). Therefore I need my
conditional formating to compare the two data sets, but with a tolerance of
plus or minus 1.00. How do I create this formula using conditional formating?