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

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: