Forum Discussion
Mel5t
Aug 03, 2023Copper Contributor
Syntax error in conditional formatting while using AND()
Hi I get an syntax error using the AND()-function in the following formula for conditional formatting: =AND(G6>Parameter!$A$4,G6<(Parameter!$A$4+30)) The cells contains dates, and i have ...
Riny_van_Eekelen
Aug 03, 2023Platinum Contributor
Since you mention a 'syntax error'. Shouldn't you be using semi-colons to separate the formula arguments? I believe that's the Norwegian locale.
Otherwise it should work, though you don't need the extra parenthesis in the second argument of the AND.