conditional formatting with traffic signal

[minesh]

Hi all,

I got a scenario were in there are 2 cells one with start date( assume its start date of insurance policy) and another one with todays date. 3rd cell display should display number of days in such a way that when date nears with only 30 days to renew the policy it should highlight red cell with traffic signal red, 90 days left with yellow cell with traffic light yellow, 180 days left with green. I tired with conditional format but not able to set it with icon sets traffic light option.

 

[Raaz108]

Hi all,

I got a scenario were in there are 2 cells one with start date( assume its start date of insurance policy) and another one with todays date. 3rd cell display should display number of days in such a way that when date nears with only 30 days to renew the policy it should highlight red cell with traffic signal red, 90 days left with yellow cell with traffic light yellow, 180 days left with green. I tired with conditional format but not able to set it with icon sets traffic light option.

Hi Your condition is not clear, However i tried to answer your Question.

Pls. find attached file for the same.

Thanks,
Raaz

 

[Nebu]

Hi:
Please find the attached, in the file any days less than 90 will be be red 90-179 will be yellow and 180+ will be green...

 

[minesh]

Thanks Raaz and Nebu for solving my query