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)