on WS_Activate, highlight row containing current date

[robertvdb]

I have a sheet with two columns A and B. A contains the dates of this month, B lists the task to perform.

When I activate the sheet, I want the row with today's date to highlight. See image.

Can anyone help ? Thanks.

 

[Joe4]

You should be able to do this easily with Conditional Formatting.

Just select the range A2 down to the end and use the Conditional Formatting formula:

=$A2=TODAY()

and choose your desired formatting color.

 

[robertvdb]

Thanks Joe, and sorry for late replying.

Whereas I am not pro conditional formatting, in some cases it is hard to avoid, especially in case of a Web-based xlsx where VBA is difficult or impossible.

Best regards and have a nice Sunday.

 

[Joe4]

You are welcome.
While I love VBA, Conditional Formatting is almost always preferrable to VBA. No need to recreate built-in functionality that Excel also has, and VBA has its own restrictions that can sometimes cause issues (i.e. cannot be used in online version, people have to make sure VBA is enabled, etc). VBA is great for handling things for which there is no built-in Excel functionality/formulas.

 

[robertvdb]

Thanks Joe. I'll keep that in mind.

One more question: would it be possible to amend your above formula, so that the shading only appears on weekdays ? See enclosed image.

 

[Joe4]

Thanks Joe. I'll keep that in mind.

One more question: would it be possible to amend your above formula, so that the shading only appears on weekdays ? See enclosed image.

Sure.

Use:

=AND($A2=TODAY(),WEEKDAY($A2,2)<6)

 

[robertvdb]

Thanks Joe ! Much appreciated !

 

[Joe4]

You are welcome