Articles | Photoshop blog | Photography blog | about me | e-mail

Helen Bradley - MS Office Tips, Tricks and Tutorials

I'm a lifestyle journalist and I've been writing about office productivity software for a long time. Here you'll find handy hints, tips, tricks, techniques and tutorials on using software as diverse as Excel, Word, PowerPoint, Outlook, Access and Publisher from Microsoft and other applications that I love. My publishing credits include PC Magazine, Windows XP mag, CNet, PC User mag, SmallbusinessComputing.com, Winplanet and Sydney Morning Herald.

Tuesday, July 3, 2007

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.

Labels: Excel 2003, highlight cells containing formulas

3 Comments:

At February 5, 2008 11:58 AM , Anonymous said...: http://exceltips.vitalnews.com/Pages/T0966_Conditionally_Highlighting_Cells_Containing_Formulas.html
At February 5, 2008 4:23 PM , Projectwoman said...: 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.
At March 19, 2009 10:47 PM , Anonymous said...: another, quite possibly better, solution:

http://www.j-walk.com/ss/excel/usertips/tip045.htm