if amount <0, put the all line in red

[doudou]

Hi,

is it possible to do that: change color of the all row when one of it
cell contains a negative amount ?

th

 

[John Michl]

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

 

[doudou]

sorry, it doesn't do the job

 

[John Michl]

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