Excel Conditional formating using formula

Solved/Closed
christossol Posts 16 Registration date Friday February 17, 2017 Status Member Last seen March 23, 2022 - Feb 26, 2021 at 01:31 AM
Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 - Feb 26, 2021 at 01:16 PM
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

Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
Feb 26, 2021 at 06:17 AM
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
Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
Feb 26, 2021 at 01:16 PM
Christossol, Good afternoon.

Thanks for the feedback.

Feeling glad to help you
---
Belo Horizonte, MG - Brasil.
Marcílio Lobão
1
christossol Posts 16 Registration date Friday February 17, 2017 Status Member Last seen March 23, 2022
Feb 26, 2021 at 12:22 PM
Dear Marcilio,

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