Cell background colour [Closed]

Report
-
Mazzaropi
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
-
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.



2 replies

Posts
14744
Registration date
Monday July 11, 2005
Status
Moderator
Last seen
February 21, 2020
3,031
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
135
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