Menu
  1. Accueil
  2. Tech Forum
  3. Office Software

Highlighting dates conditional formating [Solved/Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 -
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

2 replies

Answer 1 / 2
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 766
use conditional formatting

you have to enter three formula and choose color for each

=AND(A1<> "", a1<today())


=a1=today()


= a1> today()
2
Thank you
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Report

it works perfectly but when i save it and close the excel program and then open it again all the cells become green i tried my best to find the problem but no luck please help me I'll really appreciate it i cant even send this file to anyone because when they open it the conditions don't work all the cells becomes green....
I'm using office 2010 blue edition by the way
Report
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 766
see your other question
https://ccm.net/forum/affich-356510-excel-conditional-formatting-stops-working
Answer 2 / 2

***PROBLEM SOLVED***

THANK YOUR VERY MUCH "rizvisa1"
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!