Cell background colour [Closed]

Report
-
Posts
1894
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
March 6, 2021
-
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
14982
Registration date
Monday July 11, 2005
Status
Moderator
Last seen
March 2, 2021
1,443
Posts
1894
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
March 6, 2021
142
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!