Highlighting dates conditional formating
Solved/Closed
Baba
-
May 20, 2010 at 08:37 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 24, 2010 at 05:55 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 24, 2010 at 05:55 AM
Related:
- Highlighting dates conditional formating
- How to highlight overdue dates in excel ✓ - Excel Forum
- Different dates of "end to end encryption message" on blank chat? ✓ - Network Forum
- Defcon dates - Guide
- To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
- Webpage blank - Internet & Social Networks Forum
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 20, 2010 at 08:44 PM
May 20, 2010 at 08:44 PM
use conditional formatting
you have to enter three formula and choose color for each
=AND(A1<> "", a1<today())
=a1=today()
= a1> today()
you have to enter three formula and choose color for each
=AND(A1<> "", a1<today())
=a1=today()
= a1> today()
May 23, 2010 at 07:44 PM
I'm using office 2010 blue edition by the way
May 24, 2010 at 05:55 AM
https://ccm.net/forum/affich-356510-excel-conditional-formatting-stops-working