Excel Conditional formating using formula [Solved]

Report
Posts
15
Registration date
Friday February 17, 2017
Status
Member
Last seen
February 26, 2021
-
Posts
1914
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 7, 2021
-
Hi All Agian,

I have a table with a list of customers and i have columns with the months and on each month i enter the visit day.
I want to format cells that contain date after the today's date. Format only the cell though not the row.

Any ideas?

Thanks
Christos

System Configuration: Windows / Chrome 88.0.4324.182

3 replies

Posts
1914
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 7, 2021
142
christossol, Good morning.

Select the desired range: Ex.: B2:D12

You can use:

For only the day after today: =B2 =TODAY() + 1

For all days after today: =B2 >=TODAY() + 1

Is this what you want?

I hope it helps
----
Belo Horizonte, MG - Brasil.
Marcílio Lobão
1
Thank you

Glad we were able to help! Love us? Write us a review! Rate CCM

CCM 2942 users have said thank you to us this month

Posts
1914
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 7, 2021
142
Christossol, Good afternoon.

Thanks for the feedback.

Feeling glad to help you
---
Belo Horizonte, MG - Brasil.
Marcílio Lobão
1
Thank you

Glad we were able to help! Love us? Write us a review! Rate CCM

CCM 2942 users have said thank you to us this month

Posts
15
Registration date
Friday February 17, 2017
Status
Member
Last seen
February 26, 2021

Dear Marcilio,

Thank you very much for your prompt response. It worked perfectly!!!!!!1

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!