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

Report
Posts
5
Registration date
Thursday February 16, 2017
Status
Member
Last seen
February 21, 2017
-
Posts
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
-
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

2 replies

Posts
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
136
-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
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
5
Registration date
Thursday February 16, 2017
Status
Member
Last seen
February 21, 2017

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.
Posts
5
Registration date
Thursday February 16, 2017
Status
Member
Last seen
February 21, 2017

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..
Posts
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
136
Thanks for the feedback.
Glad to be of help.

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

Newsletter

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!