I decided to us the "Marketing Project Planner" template in excel and replaced some data. The formulas were not initially updating with the replaced data, so I edited two formulas through "Manage Rules" under Conditional Formatting.
After clicking apply the formula began to work! I thought - great! Let me edit the formulas listed as "costum1" "costum2" etc.. with their proper data names. As soon as I replaced data in the 1st formula which originally had costum1, the formulas I had fixed previously defaulted to blank cell color instead of the formula that was listed. No edits or adjustments have been able to fix the formula.
I've been reading different threads and trying troubleshoot measures but nothing is working and it's a bit frustrating.
Thank you in advance for your assistance!
