View Single Post
  #8   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 09:58:50 -0700 (PDT) schrieb
:

Where in your example do you view, edit, and add custom formulas in the conditional formatting?


you can see the rules only in Excel local. In OneDrive and Excel Online
the rules can't be seen.
The formula for row 8 is the formula I posted.
The formula for row 12 is:
=C13=MIN($C$13:$H$13)


Regards
Claus B.
--
Windows10
Office 2016