I don't even know if this is possible so I thought I'd ask this group. What I am creating is a Action item List and I want to be able to color code those items that are complete. So basically, I have a control button inserted that I'd like to fill the cells in a particular row with a particular color when the button is depressed. I know nothing about macros so I'm stuck (assuming this can even be done this way). If anyone can help me with this, or show me a different way to get the results I'm looking for, it would be much appreciated.