SOLVED

HIGHLIGHT ROW OF THE CURRENT WEEK

New Contributor

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 current week highlighted.  (Some combination of IF, THEN, TODAY, WEEKNUM, etc. in the conditional formatting, is what I've tried to get.)

 

I have ITAR sensitive information so I can't share the whole file.  But I shared a screenshot of what is safe.

2 Replies
best response confirmed by Lorenski (New Contributor)
Solution

@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. 

That was it! Thank you! I figured it wouldn't take long