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?
|