Conditional Formatting with Icon Sets

Joined
Jan 3, 2011
Messages
1
Reaction score
0
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
 

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

Top