Color code legend in Excel — Business Management Daily: Free Reports on Human Resources, Employment Law, Office Management, Office Communication, Office Technology and Small Business Tax Business Management Daily
  • LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+

Color code legend in Excel

Get PDF file

by on
in Excel Training,Office Technology

Q. I’d like to provide a “legend” so people know what the different Conditional Formatting colors mean in Excel. How can I do this?

A. Click on the Conditional Formatting button, and choose Manage Rules, and if necessary, change the Show formatting rules for: field to This Worksheet. Press Alt+PrintScreen. This captures only the resulting dialog box, which should show all your formatting and how it is applied.

{ 2 comments… read them below or add one }

Vikash October 21, 2015 at 4:38 am



Vickalash February 9, 2017 at 2:20 pm

Thanks. That was very helpful!


Leave a Comment

Previous post:

Next post: