CF using date to change Font/Backgroundcolor to another cell

Closed
edz - Jul 9, 2017 at 06:24 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 9, 2017 at 03:30 PM
Hello,

Good day,

can you help me how can I change the font/background color of another cell base from the list in another cell.

Example in A1, i have a list containing Months which is from January to December. Format required is M/DD/YYYY. If i select month of May (5/01/2017) from drop-down list in A1 cell, the b1 cell should have change to my desired font/bakground color.

glad to know your answers. Many Thanks in advance.

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jul 9, 2017 at 03:30 PM
edz, Good afternoon.

Try to do:

a) Select B1

b) Conditional Format --> Using formula
--> =MONTH(A1)=5
--> Format: Font/Fill color to desired font/bakground color

OK

Please, tell us if it worked as you desired.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0