I set up 3 conditional formating rules for a checkbook register. I set them to fill a particular color in Column B. The rule was B:B. That worked for a while, tonight it stopped. I checked the rule and it changed itself. One screen shot shows the rule.Another shot shows the register with my comments.
The only thing I did different tonight than in previous sessions was I deleted one row. That deletion caused a formula in column G to give me a REF! error for the last two rows. I fixed the error and those last two rows recalculated. However, the conditional formatting went south. I did not notice if the conditional formating was working prior to the row deletion. The last row in the screen shot of the register is 348. Can some one help me understand why my B:B changed to specific rows. Also why did the conditional formatting decide to take a day off. <https://lh5.googleusercontent.com/-X3CDjUP8P4c/VO-6aweKJOI/AAAAAAAAG-0/U32-u_uVCG8/s1600/Conditional%2BForm.png> <https://lh6.googleusercontent.com/-sHmtEoLTXJM/VO-6fqkwxzI/AAAAAAAAG-8/qkM35H_evDg/s1600/register.png> -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
