For an example on getting the fill color used in a cell or range please see Excel VBA, Get Color Code. Example: Let us look at a more practical example of changing the background color of cells. Say, in your Excel program, you have an option to change the color theme of a sheet (or part of a sheet). The main variation between the two is that Excel is a child of Microsoft while Google sheets obviously belong to Google Inc. Another thing that gives one edge over the other is that Excel has been the older of the two and has been used for a long time. On the other hand, Google sheets is a new entry and has been creating competition for Excel.

Worksheets in VBA Coding and in Worksheet Formulas (this page -- sheets.htm) Create a new sheet named with the text value of a cell with a changed value in Column F (col 6). The new sheet will be named with the change value and will also show that text value in cell A1. [posted 2004-11-05]