Cell background colour

MikeRodgers - Feb 26, 2018 at 08:14 AM - Latest reply: Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen
- 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.



See more 

Your reply

2 replies

BunoCS 13907 Posts Monday July 11, 2005Registration dateModeratorStatus June 22, 2018 Last seen - Feb 26, 2018 at 10:10 AM
Respond to BunoCS
Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Feb 26, 2018 at 10:14 AM
0
Thank you
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) http://ccm.net/forum/affich-1019399-help-conditional-cell-formatting

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

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

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

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