Hi Travis,

Use Conditional Format under Format.

For the green Cell Value Is greater than 0 Format Pattern click
green OK OK
For the red Cell Value Is equal to ="" Format Pattern click red
OK OK

HTH
Regards,
Howard

"Travis" wrote in message
...
I am setting up a spreadsheet to 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?