Related:
- Change data status in one same column
- How to change online status on whatsapp - How-To - WhatsApp
- Excel data validation list show 2 columns - How-To - Excel
- How to change phone status optimal - How-To - Android
- How to change messenger status to offline - How-To - Facebook
- Macro to sort data with respect to the column - How-To - Excel
2 replies
Mazzaropi
- Posts
- 1894
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- March 6, 2021
-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
Subscribe To Our Newsletter!
DON'T MISS
- How to Recover Your Yahoo Account
- How to Get Free Diamonds in Free Fire
- How to Recover a Disabled Facebook Account
- How to Create a Gmail Account
- How to Install a VPN
- How to Fix a Blurry Snapchat Video
- How to Disabled Write Protection on a USB
- Computer Boots to Black Screen
- How to Upload High Quality Photos to Instagram
- Facebook Code Not Received
- How to Get More Followers on Instagram
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..