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

Helen Bradley - MS Office Tips, Tricks & Tutorials

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

Add to Technorati Favorites