Sorry if this has been covered; I searched the forums and Google but could not find an applicable answer.
I have conditionally formatted cells on a spreadsheet so it is comprised of rows and columns of alternating colors. Here's a screenshot to demonstrate what it looks like:
excel 1.jpg
The conditional formatting is applied to all Columns to the right of and including Column G. Before the conditional formatting, I had applied the cell coloring by simply using the Fill Color button but found that when I added new rows/columns, the colors no longer alternated correctly. This prompted me to change to the conditional formatting option. The issue I am having now is that prior to applying the conditional formatting, I had been coloring in specific cells to denote different information. For example, in cells O132 - Q132 in the screenshot above, when I would receive a payment for that specific fee, I would apply a green fill via the Fill Color button to the cells to show that payment was not longer outstanding. Now that I have used the conditional formatting to control the general pattern for cell fill colors, I can't use the Fill Color button to alter the fill color of the affected cells. Is there a simple way that I can keep the cells conditionally formatted to display the color pattern but still allow the format to be overridden in specific instances? If this is not an option, is there a different way to apply a set alternating color scheme to the spreadsheet in general so it holds the pattern when new rows/columns are added but still allow for specific cells' colors to be easily changed?
Hopefully I have explained this clearly. If anyone needs clarification on anything, please let me know. Thanks for any help you can give.
Bookmarks