Some Formulas working, others not populating

Copper Contributor

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!

1 Reply


Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.