Thread
:
Highlighting closest value in section.
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Claus Busch
external usenet poster
Posts: 3,872
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
Reply With Quote
Claus Busch
View Public Profile
Find all posts by Claus Busch