| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare five values
Hello,
I have an excel file that will be made up of clusters of five numbers. I want a macro to check if 3 of those 5 numbers are within 0.1 of each other. If yes highlight those three numbers green. If not highlight all five numbers red. Thank you for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) | |||
| How do i compare values from two sheet and copy & paste if values match? | Excel Programming | |||
| Compare Listbox values with Collection values | Excel Programming | |||
| compare values between workbooks and copy values | Excel Programming | |||
Threaded Mode
