Cell background colour [Closed]

Report
-
Posts
1934
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
July 21, 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
15102
Registration date
Monday July 11, 2005
Status
Moderator
Last seen
July 27, 2021
1,507
Posts
1934
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
July 21, 2021
144
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!