Friday, July 17, 2015

Displaying Images in Excel Based on a Result

If you've worked with me at all, you know that I'm always looking for ways to do things smarter, faster, and more efficient. I recently was challenged with developing a visual status report for a project, and the project manager wanted to use specific icons. Though Excel has a decent selection of icons to use for conditional formatting, the request for specific icons created a challenge for me. Thankfully, I found the following tip from Allen Wyatt. Though the set-up is involved, the time saved will be priceless.

Below is the beginning of my efforts using custom icons.





No comments:

Post a Comment