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?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question