Cor
In Excel 97 up, check out conditional formatting
FormatConditional Formatting
'Cell Value is' 'equal to' -1
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS
"Cor" wrote in message
...
Can i color a cell in Excel when the criteria is met.
e.g. when a value is -1 i want to color it red automatically.
Cor