Would you like to change the format of all your formula cells so they have a different fill colour or font? There is a way in Excel 2013 onwards.
In a recent webinar on conditional formatting I was demonstrating how to create a horizontal progress bar using conditional formats when someone asked an interesting question about creating a vertical progress bar. It is possible and in this blog post I will explain both techniques.
Pain is inevitable. Suffering is optional.
Old Buddhist saying
When you record a macro that refers to a particular cell or range on a particular sheet in Excel the range reference is hard coded into VBA (macro) code. Unfortunately this means if rows or columns are inserted or deleted in the reference range the code is not updated. There is an easy way to get around this.
Take care of your body. It’s the only place you have to live.
Jim Rohn (1930 – 2009)