Negative value

[mpele]

Haw could I change color of one field if in coloumn A is one or mor
negative values

 

[Bob Phillips]

Conditional Formatting

Select column A
Menu Format>Conditional Formatting
Set a condition
Click the Format button
Select the Pattern Tab
Select an appropriate highlighting colour
OK
OK

Second condition

Click Add
Set another condition
Click the Format button
Select the Pattern Tab
Select an appropriate highlighting colour
OK
OK

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)