Previous Topic Next Topic

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

Answer 1 / 2
BunoCS Posts 15472 Registration date Monday July 11, 2005 Status Moderator Last seen March 25, 2024 1,534
Feb 26, 2018 at 10:10 AM
Hello,

Yes, it is a conditionnal format.
https://ccm.net/forum/affich-756543-changing-cell-background-color-based-on-another-cells-background
0
Answer 2 / 2
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
0

Similar discussions

Counting cells containing only numbers
jutulu -
jutulu -

4 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses