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
- Change data status in one same column
- Macro to sort data with respect to the column » How-To - Excel
- OoVoo - Change your Status » How-To - Instant Messaging
- Skype for Windows 8 - How to change your status? » How-To - Windows 8
- WhatsApp Messenger - How to change your status » How-To - Mobile
- Change the Status of a Network Profile in Windows 10 » How-To - Windows
4 replies
-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
Was this answer helpful?
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.
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..