I like to color-code certain cells in my spreadsheets. For example, I like to make the background of input cells blue, and I like to color cells with decision variables red. This is easy enough with the Fill Color (paint can) dropdown list on the Home ribbon, but it is even easier if I create color buttons on my QAT. Try doing this with the recorder. Open a blank file, select any range, turn on the recorder, and color the background a color of your choice. Make sure you store the macro in your Personal Macro Workbook. Then create a button with an appropriate icon on your QAT to run this macro. (Note: By selecting the range before you turn the recorder on, your macro will be more general. It will color whatever range happens to be selected when you run it.)

Please show vba code to do this