Hi, does anyone know how to correct the Spending Trends Tab so that Category headers automatically are highlighted with Grey Fill? It did it before, but now does not automatically adjust as different categories are added. Please help! 
Do you mean in the data table below row 10? If you click on cell B11 and then open Conditional Formatting, you should see the existing rules and be able to modify the applied formats.
2 Likes
Yes, and sorry just seeing this. Unfortunately, the conditional formatting formulas are a bit much to follow. There shouldn’t need to be an update correct? Essentially, each time a new category group is added it should auto update as a bolded and grey highlighted line no?
Hi @cjbanks415 Group names are in bold and gray. Have you already tried restoring the Spending Trends sheet?
1 Like
I had not due to the concern around losing data. I’ll try the Archive option and report back if there are any issues! Thank you!
The Restore worked, thank you! I also now see how to update the conditional formatting to match my needs! @randy Thank you!
1 Like
Good work, @cjbanks415. Now you’re a superuser.