View Single Post
  #1   Report Post  
Space Ape
 
Posts: n/a
Default Conditional formatting

I am trying to use following formula in conditional formatting field.

=if(g5=weeknum(today(),2),true,false)

I get an error...

But the same formula works fine when pasted in a cell.

I need to set condinal formatting according to the formaul.
I think there is someway to work around.

Could some one help me, please?