Ask a question
The Best of CCM in Your Inbox
The information gathered is for Communitic International to ensure the sending of the newsletter.
The information will be used subject to terms and conditions, for advertising purposes.
You reserve the right to access and change your personal data, aswell as the right to request its deletion within the limits permitted by law.
You can also review your targeting options. For more information, click this privacy policy .
DON'T MISS
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..