Feb 13 2024 06:54 AM
Hello i like to have conditional formatting on my excel if numer of week on column G (start row 😎 is different from actually week numer.
For example today we are on weeknumer 7.
I need to formatting and lock if numer is differet. I try this formula but not working
=weeknumber($G8)<>weeknumber(today())
But not work. This is my sheet
INFO | CHECK | WK |
1 | ||
2 | ||
3 | ||
4 | ||
5 | ||
6 | ||
7 | ||
8 | ||
9 | ||
10 |
Feb 13 2024 07:52 AM - edited Feb 13 2024 07:53 AM
Feb 13 2024 07:55 AM