View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] alexc.rrandall@gmail.com is offline
external usenet poster
 
Posts: 5
Default Highlighting closest value in section.

On Friday, May 24, 2019 at 10:48:42 AM UTC-5, wrote:
C D E F G H I
8) 39.4% 36.9% 24.70% 49.00% 49% 24.80% 47.70%

How do I highlight in conditional formatting the closes value in C8:H8 to I8?

Thanks in advance!


The Helper row and that last formula worked. Thanks you