Conditional formatting skipping blank cell [SOLVED]

I have LO 7.0.4.2 on a MX Linux, I had created a conditional formula that will highlight the min cell in a row, the problem is the cell range contains empty/blank cells, how do I skip those blank cells? Currently the blank cells are highlighted as well (as being the lowest value).
ps: I’m using formula MIN in the conditional formatting (if this will help).

Try this formula (using the range A1:A10 as an example):

IF(AND(A1=MIN($A$1:$A$10);ISBLANK(A1)=0))
1 Like

Sorry

I did not see any Difference compared to:

Cellvalue  … equal to … MIN($A$1:$A$10)

so, whats the purpose of …ISBLANK… ??

There will be zero in at least one cell.

2023-06-05 07 29 18

Hallo

Ok I see the problem… but why does MIN(…) skip blank cells only if there are no real zeros?

This function ignores any text or empty cell within a data range.

Returns 0 if no numeric value and no error was encountered in the cell range(s) passed as cell reference(s).

Thanks to sokol92, his solution solved my problem
Try this formula (using the range A1:A10 as an example):

IF(AND(A1=MIN($A$1:$A$10);ISBLANK(A1)=0))