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
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