Forum Discussion

Lorenski's avatar
Lorenski
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's avatar
    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's avatar
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. 

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

Resources