Forum Discussion

Copper Contributor

Apr 15, 2022

Solved

HIGHLIGHT ROW OF THE CURRENT WEEK

I've looked around and tinkered. I just can't land on the right formula, and everyone's situation is slightly different. I need to be able to open up my Excel document and have the row of the cu...

Charting

excel

Formulas and Functions

OliverScheurich
Apr 15, 2022
Lorenski
=$E3=ISOWEEKNUM(TODAY())
Maybe with this rule for conditional formatting.
=$E$3:$N$28
The format is applied to the above range in the attached file.

OliverScheurich

Gold Contributor

Apr 15, 2022

Lorenski

=$E3=ISOWEEKNUM(TODAY())

Maybe with this rule for conditional formatting.

=$E$3:$N$28

The format is applied to the above range in the attached file.

Skaur1560
Copper Contributor
Sep 29, 2022
OliverScheurich
hey i'm trying to do something similar and hoping you can help please as I've been struggling for far too long!
I am trying to do a border around the column under this week's date (as shown in col G) but can't seem to do it. At the moment I am doing it manually but there are a lot of tabs so would love for it to update automatically. Are you able to help me pretty please? Note, I'm using Excel not Google Sheets. Screenshot here-
https://drive.google.com/file/d/1GG_cZQ0ZCzG47NPOqRPLEbT4Y4FURD0C/view?usp=sharing

Thank you!
Lorenski
Copper Contributor
Apr 15, 2022
That was it! Thank you! I figured it wouldn't take long 🙂