Change cell format (cell color+font color) based on color of another cell

I filled rows 1 and 2 with black so I can see what the contents of the cells are. I added a "helper" row that gets the colors associated with the check boxes and stores the color number as a long. You can unfill the cells to hide the values.

The program also uses a helper sheet called Remember - this sheet can be hidden. When you clear a certain color on the chart, the program goes through the F20:AU42 range and "remembers" the color associated with the cell. When you turn that color back on, the program fetches the color value from the remember sheet and applies it to the cell.