Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to get excel cells to change colors depending on value
I'd like to know if anyone knows how to get excel cells to change color
depending on their value. We're working with a database and want cells to turn one color when the value is positive and another color when the value is negative. Thanks for the help, KV |
#2
|
|||
|
|||
Hi,
highlight the cell and click format|conditional formating peter -----Original Message----- I'd like to know if anyone knows how to get excel cells to change color depending on their value. We're working with a database and want cells to turn one color when the value is positive and another color when the value is negative. Thanks for the help, KV . |
#3
|
|||
|
|||
"peter" wrote ...
cells to turn one color when the value is positive and another color when the value is negative. highlight the cell and click format|conditional formating Also, can use the older style custom number formats e.g. [Blue]General;[Red]-General;[White]General Anyone know where that KB article with details on these formats or has a copy somewhere? Jamie. -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
EXCEL cells colors | Excel Discussion (Misc queries) | |||
linking cells in Excel 2003. How to not truncate to 255 characters. | Excel Discussion (Misc queries) | |||
How do I change an Excel range of cells from relative to absolute. | Excel Worksheet Functions | |||
stop excel from shifting cells up when a query returns no data | Excel Worksheet Functions |