color cells when criteria is met
 

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

Formatconditional formatting, cell value is

Regards,

Peo Sjoblom

"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

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