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
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
Format>conditional formatting, cell value is
Regards,
Peo Sjoblom
"Cor" <[email protected]> wrote in message
news:[email protected]...
> 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
Format>Conditional Formatting
'Cell Value is' 'equal to' -1
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]HIS
"Cor" <[email protected]> wrote in message
news:[email protected]...
> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks