Colors driving me crazy!
 

I am trying to 'record' the selection of certain colors from the Themed color
pallettes available in Excel 2007. For example, I went under Page Layout and
selected the top 'Color Theme' (Office). When I recorded my macro, I
selected two cells & colored them two different shades of green from this
pallette. When I played back the macro, one of the colors worked fine, the
other was some funky shade of blue. I've tried this multiple times, but
keep getting errant results no matter what I do -- one color is "good", the
other is "bad". What am I doing wrong??