Conditional formatting using icon sets in excel 2007

Carla

Guest

Posts: n/a

9th Oct 2009

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

« Variable error on second use??? | Close DropDown of ComboBox2 & Open ComboBox1 on Error »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Icon Sets Conditional Formatting in Excel 2007	peedub	Microsoft Excel Discussion	4	19th Oct 2011 07:40 AM
Conditional Formatting with Icon Sets	gstambo	Microsoft Excel Worksheet Functions	0	3rd Jan 2011 09:57 PM
Conditional formatting and icon sets	Tim	Microsoft Excel Discussion	0	11th Oct 2010 03:03 PM
Icon sets - conditional formatting - in Excel 2003	Lou	Microsoft Excel Worksheet Functions	1	14th Apr 2010 04:57 AM
Conditional formatting with icon sets	Tim	Microsoft Excel Discussion	1	9th Apr 2009 12:21 AM