View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Highlighting closest value in section.

Hi,

Am Fri, 24 May 2019 08:48:38 -0700 (PDT) schrieb
:

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?


select C8:H8 and use following formula in conditonal formatting:
=ABS($I$8-C8)=MIN(ABS($I$8-$C$8:$H$8))


Regards
Claus B.
--
Windows10
Office 2016