Negative value

B

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)
 
Top