Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - Color changing cells
I have inherited an Excel spreadsheet. One section of the spreadsheet has
calculations and the cells are colored. The numeric value in the cell determines the cell color. I'm not sure how the author made the cells change color (and the author is not available anymore). I have click on the color changing cell and I can't see any special code that would tell the cell to turn a certain color for a given number. Any thought on how this might have been done? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - Color changing cells
Select the cell and then from the XL menu select Format - Conditional
Format... -- HTH... Jim Thomlinson "Sammy" wrote: I have inherited an Excel spreadsheet. One section of the spreadsheet has calculations and the cells are colored. The numeric value in the cell determines the cell color. I'm not sure how the author made the cells change color (and the author is not available anymore). I have click on the color changing cell and I can't see any special code that would tell the cell to turn a certain color for a given number. Any thought on how this might have been done? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2003 shading cells and changing font colors does not work | Excel Discussion (Misc queries) | |||
Excel 2003, will not let me color fill cells | Excel Worksheet Functions | |||
How do I get more color options for fill in for cells, excel 2003? | Excel Worksheet Functions | |||
Excel 2003 will not display color fonts or color fill cells | Excel Worksheet Functions | |||
My excel 2003 wont let me fill cells with color or color the tabs. | New Users to Excel |