Excel - highlight cells containing formulas
There's no shortcut way to color code cells in Excel which contain formulas but this workaround is simple and fast.
Choose Edit, GoTo, Special button and click Formulas and then Ok. Now fill the cells with a color using the Fill Color tool.
It's now clear which cells contain formulas and those that do not.
posted by Jane @ 6:08 PM
3 Comments:
http://exceltips.vitalnews.com/Pages/T0966_Conditionally_Highlighting_Cells_Containing_Formulas.html
Thank you for the last post. The solution looks good, it's not for the faint of heart but if you're not afraid of writing a line or two of code, it is a neat fix.
another, quite possibly better, solution:
http://www.j-walk.com/ss/excel/usertips/tip045.htm
Post a Comment
Please feel free to add your comment here. Thank you!
Subscribe to Post Comments [Atom]
<< Home