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
Hello,
How to highlight dates in "EXCEL" i mean
Less than Today = RED
Today = YELLOW
Greater than Today = Green
Please help me i've been trying this for more than 2 months but couldn't find it
Thanks in advance
How to highlight dates in "EXCEL" i mean
Less than Today = RED
Today = YELLOW
Greater than Today = Green
Please help me i've been trying this for more than 2 months but couldn't find it
Thanks in advance
Related:
- Highlighting dates conditional formating
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Different dates of "end to end encryption message" on blank chat? - Excel Forum
- How to highlight overdue dates in excel ✓ - Excel Forum
- Defcon dates - Guide
- Apple iphone 13 release dates - Guide
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