Forum Discussion

lifesafari's avatar
lifesafari
Copper Contributor
Feb 13, 2024

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 

INFOCHECKWK
  1
  2
  3
  4
  5
  6
  7
  8
  9
  10

Resources