Conditional formatting using icon sets in excel 2007

C

Carla

I am using Excel 2007. I have a column called test completed that is
populated with an X if the student has completed that test. I would like to
have the X replaced with the conditional icon set using a checkmark called 3
symbols uncircled. I want a red x if it is not completed and I really don't
need the yellow Exclamaion mark.

Can this be done?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting with VBA 4
VBA Conditional Formatting .IconSets plus one other icon/symbol 14
Icon Sets in Conditional Formatting 5
How to display an "icon" instead of cell value 1
Conditional Formatting in VB 0
Copying Conditional Formatting With Icon Sets 8
Look up by the Icon Set Color 0
Conditional Formatting of Percentages 2

Top