| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Highlighting closest value in section.
It doesn't appear to be working properly. I am using Google Sheets, is that the issue? It highlights all the variables rather than the one closest to I8.
|
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Highlighting closest value in section.
Hi,
Am Fri, 24 May 2019 09:11:34 -0700 (PDT) schrieb : It doesn't appear to be working properly. I am using Google Sheets, is that the issue? It highlights all the variables rather than the one closest to I8. in Excel it works fine. Ask the Google support for a solution or you have to use a helper row. Regards Claus B. -- Windows10 Office 2016 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Highlighting closest value in section.
Hi again,
Am Fri, 24 May 2019 09:11:34 -0700 (PDT) schrieb : It doesn't appear to be working properly. I am using Google Sheets, is that the issue? It highlights all the variables rather than the one closest to I8. have a look: https://1drv.ms/x/s!AqMiGBK2qniTgeMv91yjfQu5D4QRPA Regards Claus B. -- Windows10 Office 2016 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Highlighting closest value in section.
I'm looking over it. Thank you for your help.
|
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Highlighting closest value in section.
Where in your example do you view, edit, and add custom formulas in the conditional formatting?
|
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to determine the closest value? | Excel Discussion (Misc queries) | |||
| How do I: If Pie Section Label = X, Make Pie Section Color = Y | Excel Programming | |||
| Array Lookup to Find Closest Date and Next Closest Date | Excel Worksheet Functions | |||
| Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. | Excel Discussion (Misc queries) | |||
| Closest-to function | Excel Programming | |||
Linear Mode
