Forum Discussion
lifesafari
Feb 13, 2024Copper Contributor
Conditional formatting if weeknum is different
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 |
2 Replies
- Riny_van_EekelenPlatinum Contributor