Change data status in one same column
Solved/Closed
-Hta-
Posts
5
Registration date
Thursday February 16, 2017
Status
Member
Last seen
February 21, 2017
-
Updated by Ambucias on 16/02/17 at 07:27 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Feb 17, 2017 at 06:40 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Feb 17, 2017 at 06:40 AM
Related:
- Change data status in one same column
- Viber online status - Guide
- Viber seen status - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Change computer name cmd - Guide
- Display two columns in data validation list but return only one - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Feb 16, 2017 at 11:52 AM
Feb 16, 2017 at 11:52 AM
-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
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
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Feb 17, 2017 at 06:40 AM
Feb 17, 2017 at 06:40 AM
Thanks for the feedback.
Glad to be of help.
Have a nice day!
--
Belo Horizonte, Brasil.
Marcílio Lobão
Glad to be of help.
Have a nice day!
--
Belo Horizonte, Brasil.
Marcílio Lobão
Feb 16, 2017 at 09:58 PM
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.
Updated by -Hta- on 17/02/17 at 05:40 AM
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..