Cell background colour

Closed
MikeRodgers - Feb 26, 2018 at 08:14 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Feb 26, 2018 at 10:14 AM
Hello, Is it possible for a cell to change colour as a warning that the date in the cell is nearing going out of date.



Related:

2 responses

BunoCS Posts 15479 Registration date Monday July 11, 2005 Status Moderator Last seen June 25, 2024 1,533
Feb 26, 2018 at 10:10 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Feb 26, 2018 at 10:14 AM
MikeRodgers, Good morning.

You can use a Conditional Formatting to do what you want.
There are a lot of the same case in this forum.

There are some of them:
a) https://ccm.net/forum/affich-1019399-help-conditional-cell-formatting

b) https://ccm.net/forum/affich-1032006-conditional-formatting-dates#p1032188

c) https://ccm.net/forum/affich-1032496-how-to-apply-conditional-formatting#p1032507

d) https://ccm.net/forum/affich-1035326-row-conditional-formating-in-excel#p1035559

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