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?

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?