if amount <0, put the all line in red
 

Try conditional formating for the row.
Click on the row number to format
Select Format | Conditional Formating from the menu
Switch from Cell Is to Formula in the drop down
Add a formula like $A$1 < 0
The select the formating options you want.

Hit ok and you should be in business.

- John Michl
www.johnmichl.com

sorry, it doesn't do the job


--
doudou
------------------------------------------------------------------------
doudou's Profile: http://www.excelforum.com/member.php...o&userid=24047
View this thread: http://www.excelforum.com/showthread...hreadid=399280

Sorry I misread your request. The formula should be something like
= min($1:$1)<0
where 1 is the row number. Note that there should be no quotes in the
formula. The first time you type it in, Excel may put quotes around it
so you'll need to edit it to remove them.

- John