color cells when criteria is met

C

Cor

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
 
N

Nick Hodge

Cor

In Excel 97 up, check out conditional formatting

Format>Conditional Formatting

'Cell Value is' 'equal to' -1

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
Top