Share via

Conditional formatting highlight a row based on date in another column

Anonymous
2022-06-07T16:03:59+00:00

I am trying to make a rule with conditional formatting that would highlight an entire row based on dates occurring this week (in another column). I have my dates set up to show only Mondays (ex: 1/1, 1/8) in column B (screenshot below)

I am hoping someone could help me figure out the equation to use for conditional formatting or another alternative. Thank you!!

Microsoft 365 and Office | Excel | For home | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-06-07T16:27:43+00:00

    Hi Maddie

    Let's say your only Monday dates start in cell B2 then, use the following CF formula

    =WEEKNUM($B2,2)=WEEKNUM(TODAY(),2)

    I hope this helps you and gives a solution to your problem

    Do let me know if you need more help

    Regards

    Jeovany

    0 comments