E
ExcelHasMeBeat
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?
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?