Conditional Formatting with Icon Sets

gstambo

New Member

Join Date: Jan 2011

Posts: 1

3rd Jan 2011

I want to apply conditional formatting to a column of cells that have different dates. The intent is to apply a red stop light to those dates between today and today+30, a yellow light for cells with dates between today+31 and today+60, and a green traffic light for cells with dates between today+61 and today+90.

I find it very easy to apply highlighted conditional formatting, but cannot figure out how to achieve the desired effect with the icon sets.

Thanks for your help!

Glen

« How do I unlock excel worksheet with lost password? | Adding days by using NETWORKDAYS 2007 formula »

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
Conditional formatting and icon sets	Tim	Microsoft Excel Discussion	0	11th Oct 2010 03:03 PM
Conditional Formatting and arrow icon sets	Mark	Microsoft Excel Misc	0	24th Sep 2009 01:28 AM
Conditional formatting with icon sets	Tim	Microsoft Excel Discussion	1	9th Apr 2009 12:21 AM
Conditional Formatting with Icon sets	CC	Microsoft Excel Misc	3	31st May 2008 12:37 AM
Icon Sets in Conditional Formatting	Brandon_469	Microsoft Excel Programming	5	10th May 2008 04:55 PM