• 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.

{ 3 comments… read them below or add one }

buy a bus November 25, 2018 at 12:42 am

Gօod post! We are linking tⲟ this paгtіcularly great content on оur website.
Keep up the ցood writing.


Vikash October 21, 2015 at 4:38 am



Vickalash February 9, 2017 at 2:20 pm

Thanks. That was very helpful!


Leave a Comment