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.
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.
Related posts:
Labels: Excel 2003, highlight cells containing formulas
Labels:Uncategorized
Post a Comment
Please feel free to add your comment here. Thank you!