Apr 15 2022 10:01 AM
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.
Apr 15 2022 10:10 AM
Solution=$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.
Apr 15 2022 10:18 AM