Howdy mstillwago, welcome to the board.
cell value is equal to =MAX(row#:row#)
cell value is equal to =min(row#:row#)
Hope this helps.
Edit: apply the format to the entire row, you can select the row while doing this.
Cheers, Nate Oliver
[ This Message was edited by: NateO on 2002-12-04 17:50 ]