if amount <0, put the all line in red

D

doudou

Hi,

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

th
 
J

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.
Click to expand...

Hit ok and you should be in business.

- John Michl
www.johnmichl.com
 
J

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
 
Top