Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
    
Just to clarify, which are you actually using- Works Spreadsheet or Excel? – Adam Ryan Oct 31 '09 at 1:25
    
works spreadsheet... – joe Oct 31 '09 at 17:40
up vote 4 down vote accepted

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:

Result in OpenOffice.org

share|improve this answer
    
thanks Arjan ............ – joe Nov 6 '09 at 14:29

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .