View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
chemtyra chemtyra is offline
external usenet poster
 
Posts: 4
Default 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.