How to dynamically highlight the minimum value in Excel or OpenOfficedotorg Calc?

How to dynamically highlight the minimum value in Excel or OpenOfficedotorg Calc? I am using Microsoft spreadsheet to record the numeric values in columns. I would like to compute the minimum of the row and want to highlight it when the cursor moves to next row.
Asked by: Guest \| Views: 281

Total answers/comments: 1

Comments display order:

bert [Entry]

"To highlight it right away (without actually moving to the next row), use conditional formatting, like:

Cell value is less than or equal to MIN($A1:$ZZ1)

In OpenOfficedotorg:"