I really need help on this, please! I had conditional formatting set up and it was working fine. I've been adding VBA codes for different things and everything had been working together. Suddenly on one file, the formatting has stopped. I have the exact same codes in another file and everything works fine there. Do VBA codes interfere with conditional formatting? How do I find/fix the issue? The files are so big there's no way I can go back and redo all the formatting with the amount of time I have.
The formatting only updates once I press save. Even though it is set up to update automatically per:
"1. Just set up your conditional formatting in the cell's you want.
2. Make sure you activate the "Developer" tab in the menu.
3. Do this by clicking on the Office button, click on Excel options and in the "Popular" section check the box ""Show developer tab in the Ribbon".
4. Click on the Developer menu and go to the Visual basic view.
5. Click on the menu View and select "properties Window". In that list you can find the "EnableFormatConditionsCalculation".
6. Set this value to "True" and the auto refresh will work.
7. Perform this action for all tabs in your sheet."
Bookmarks