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.

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))
```