Conditional Formatting - icon sets

Hello Cathy,

Thank you for your question regarding using a key to explain what parameters have been used in conditional formatting.

If you click wherever you have cells that are conditionally formatted then choose Manage Rules then click the edit rule button. You can now see the paramenters for your icon sets. Now all you have to do is print the screen using the PrtSc button and then crop the picture as desired.

Place the key above the data and then freeze panes so that whenever you scroll down the key will always be visible.

I have attached a sample file which shows the key.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer