Automated calculation and formatting Excel macro |
|
| Very often we wish to automate our calculations and highlight certain data for quick reference. This can be achieved by using a 'do while loop' macro which automates the process of calculation based on certain criteria. Next using 'if' we highlight the data also based on some conditions in the macro. The Excel training video describes this process. You can pause the video to note the details! |
|
|
|
|