Yes, I did try (i.e. putting "no fill" into the cell). The video actually has no fill. I didn't see anywhere in the video of the conditional formatting working. The color only changed when I highlight the cell.

As for the conditional formatting written into the VBA... yes, that is what I am trying to do. I can remove all that and replace it with regular conditional formatting not tied to VBA.

However, the problem still remains that the cells do not change colors with the regular conditional formatting. It does work in cells not in the body of the spreadsheet (i.e. some cell off the main part of the sheet). So the cells are formatted or something, that prevents them from changing colors. What that is, I have no clue. What could be doing that?