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

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.

Leave a Comment