Thread: Highlighting closest value in section.
View Single Post
  #1   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.

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!
Reply With QuoteReply With Quote