| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I change the color of a cell dependant upon the cell's con.
I am setting up a spreadsheet o track my store's daily sales. What I am
trying to do is to change the color of the cells depending on what the sales total for the day is. For example if the daily total is $0 the cell would be red, if the daily total was not zero the cell would be green. Any help? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do I change the color of a cell dependant upon the cell's con.
conditional formatting would be the way to do this. See Debra Dagleish's
page showing the basics: http://www.contextures.com/xlCondFormat01.html -- Regards, Tom Ogilvy "Travis" wrote in message ... I am setting up a spreadsheet o track my store's daily sales. What I am trying to do is to change the color of the cells depending on what the sales total for the day is. For example if the daily total is $0 the cell would be red, if the daily total was not zero the cell would be green. Any help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change the font on a text box dependant on another cell value | Excel Discussion (Misc queries) | |||
| Have row color change to one of 8 different colors based on one cell's value (I, O, C, T, L, E, X, A) | Excel Discussion (Misc queries) | |||
| In Excel is there a function to change a cell's background color? | Excel Worksheet Functions | |||
| change cell background color when another cell's value = 40 | Excel Discussion (Misc queries) | |||
| Change a cell's fill color dynamically? | Excel Discussion (Misc queries) | |||
Linear Mode
