Change data status in one same column [Solved/Closed]

-Hta- 5 Posts Thursday February 16, 2017Registration date February 21, 2017 Last seen - Feb 16, 2017 at 01:28 AM - Latest reply: Mazzaropi 1829 Posts Monday August 16, 2010Registration dateContributorStatus May 7, 2018 Last seen
- Feb 17, 2017 at 06:40 AM
Hello,

i am looking for a command that can use to change data status in one same column.
Example :
'Activated' change to 'Expired' when it due.


Thank You
See more 

4 replies

Mazzaropi 1829 Posts Monday August 16, 2010Registration dateContributorStatus May 7, 2018 Last seen - Feb 16, 2017 at 11:52 AM
+1
Helpful
-Hta-, Good afternoon.

Your request is very superficial.
That way it's not possible to help you conclusively.

But....
Suppose:

A1 --> DATE to compare

D1 --> STATUS --> FORMULA

=IF (TODAY() <= A1, "Activated", "Expired")

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Was this answer helpful?  
-Hta- 5 Posts Thursday February 16, 2017Registration date February 21, 2017 Last seen - Feb 16, 2017 at 09:58 PM
Hi Mazzaropi, Good Day!

TQ for your replied, I think your formula is working.

But, is it posibble to choose colour for 'Activated' as green and 'Expired' as red?
..and is it posible to highlighted 'Expired' 7 days before due?

Anyway, thanks for helping.
-Hta- 5 Posts Thursday February 16, 2017Registration date February 21, 2017 Last seen - Feb 17, 2017 at 05:40 AM
Hi Mazzaropi, Good Day!

I just discovered how to choose colour for both status by using :

Conditional Formating>Highligt Cell Rules>Text that Contain : Active with Green fill with White text> save

Conditional Formating>Highligt Cell Rules>Text that Contain : Expired with Red fill with White text> save

for to highlight 'Expired' 7 days before due, I just add +7 on formula:

=IF (TODAY()+7<= A1, "Activated", "Expired")

Thanks Again!
This forum very useful for whom wish to learn it deeply..
Mazzaropi 1829 Posts Monday August 16, 2010Registration dateContributorStatus May 7, 2018 Last seen - Feb 17, 2017 at 06:40 AM
0
Helpful
Thanks for the feedback.
Glad to be of help.

Have a nice day!
--
Belo Horizonte, Brasil.
Marcílio Lobão