Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
D
D
Dmitry2021-10-01 13:56:55
excel
Dmitry, 2021-10-01 13:56:55

How to highlight in Excel the minimum value in a row, but if it is greater than zero?

Through conditional formatting using the formula
=C22=MIN($D22;$F22;$H22;$J22;$L22;$N22)
selects empty cells as minimum.
How to ignore empty cells?

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

0 answer(s)
Similar questions
A
artfox132021-09-22 12:05:16
How to make formulas if, in exl, take values ​​from one page, find what they are equal to on another page? 0Reply
K
KirillBA2018-06-26 12:08:24
How to conditionally (through the if formula) display a pop-up list? 0Reply
M
Maxim Obukhov2013-10-06 18:52:50
ScrollLock turns on spontaneously? 4Reply
D
Damian Lewis2020-07-04 15:36:37
How to arrange text in excel columns? 1Reply
I
Ivan Melnikov2020-07-06 17:26:19
Is it possible to create a table in Excel, the number of rows in which will depend on the parameter (value in the cell)? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question