Previous Topic Next Topic

Excel Conditional formating using formula

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

Answer 1 / 3
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
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
Answer 2 / 3
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
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
Answer 3 / 3
christossol Posts 15 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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response