PDA

View Full Version : [SOLVED] Can this be done in a formula?



blackie42
05-08-2014, 07:39 AM
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
05-08-2014, 09:19 AM
Change your formula to

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

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

blackie42
05-12-2014, 03:58 AM
Just the job - thanks