| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Max value that meets a criteria | Excel Worksheet Functions | |||
| SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
| "criteria" in a sumif refering to the value in another cell | Excel Discussion (Misc queries) | |||
| SUM IF Criteria | Excel Worksheet Functions | |||
| Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions | |||
Linear Mode
