Can this be done in a formula?

[blackie42]

Hi,

I have a spreadsheet which tracks the date an issue was opened in Col A. In Col B I have a formula =TODAY()- Col A which tells me how long the issue has been open.
In Col C there is a status (dropdown) Open or Closed.

What I would like to do is add some formatting to the number of days its open so green under 90, amber over 90, and red over 150 which should be able to manage.

What I would like to do is by changing the dropdown from Open to closed is remove the formatting and blank the cell contents.

Any help appreciated
thanks

[Bob Phillips]

Change your formula to

=IF(C2<>"Closed",TODAY()-A2,"")

and include C2<>"Closed" in your CF test.

[blackie42]

Just the job - thanks