| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing 2 sets of data to fill in gaps | Excel Worksheet Functions | |||
| displaying missing data by comparing two sets | Excel Discussion (Misc queries) | |||
| Comparing two data sets | Excel Worksheet Functions | |||
| Comparing two different sets of data with common element | Excel Worksheet Functions | |||
| Comparing two sets data for different month | Excel Discussion (Misc queries) | |||
Threaded Mode
