I have a standard form I use that requires an row to be highlighted one of 7 colors when a condition is met in a cell in that row. The form varies wildly in length. Currently, I am using conditional formatting for this behavior. However, every time I delete or add rows, it breaks apart the conditional formatting into 2 pieces. This causes some issues and "managing the rules" is pretty time consuming. One thought I had would be to keep the formatting on another sheet in the workbook that I do not edit, and then applying it at the end, if that is possible. Has anyone found a work around for this? Is this kind of entire row formatting with color based on one cell possible in a way that does not require conditional formatting?
Asked
Active
Viewed 77 times
1
-
What do you have to update to make the conditional format work? Is it updating certain cells? – wbeard52 Jul 29 '14 at 00:30
-
Try applying the conditial formatting to the entire spreadsheet. – Kevin Jul 30 '14 at 06:25