Change color of current month only...

[Kutar]

Thank you for your help in the past!

Step 1: In cell B1, my VBA puts the # of the current month using MONTH(TODAY()). This can change if you know a better way.

Step 2: In column B2:B20, there are random 3 letter months
B2 = FEB
B3 = MAR
B4 = AUG
B5 = FEB
B6 = DEC
B7 = JAN
B8 = AUG
B9 = JAN
etc

Step 3: Knowing that the number in B1 (from Step 1) will change each month, I'm trying to get the current month(s) in B2:B20 to change its font to BOLD RED color. So above, the two FEB should turn to BOLD RED color and the rest would remain unchanged..


Can you help please?
Thank you,
Kutar

 

[Jonmo1]

You don't need B1 at all...

In conditional formatting for cell B2, select "Formula is"

=MONTH("1-"&B2)=MONTH(TODAY())

 

[Weaver]

select B2:B20, and choose conditional formatting from the format menu

In the dialog, choose 'formula is' and set the formula to =B1

Then set your format to whatever colour etc you need

HTH

 

[lenze]

Hi and welcome to the board!!
Other than for reference, cell B1 is irrelevent!!
Use Conditional Formatting for B2:B20, Formula Is

=B2=TEXT(TODAY(),"mmm")

lenze