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

ProjectWoman

Welcome to Helen Bradley's Microsoft Office and productivity blog. I'm a lifestyle journalist specializing in business and consumer software and here you'll find handy hints for using software such as Microsoft Office 2007 and other office applications. Elsewhere on projectwoman.com you'll find tutorials, articles, how tos and tips on photography and Photoshop CS3. My publishing credits include PC Magazine, Windows XP magazine, CNet, PC User magazine, InformIT and others.

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: ,

posted by Projectwoman @ 6:08 PM

Add to Technorati Favorites

2 Comments:

At February 5, 2008 11:58 AM , Anonymous Anonymous said...

http://exceltips.vitalnews.com/Pages/T0966_Conditionally_Highlighting_Cells_Containing_Formulas.html

 
At February 5, 2008 4:23 PM , Blogger 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.

 

Post a Comment

Links to this post:

Create a Link

<< Home