How to dynamically highlight the minimum value in Excel or OpenOffice.org Calc?

Question

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.

Could you kindly suggest alternatives to do this ?

Edit 2 :

If this possible in Excel or OpenOffice.org Calc?

Answer 1

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 OpenOffice.org: