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 testet both the conditions seperately. Both works.
Im using excel in office 365 and i have Norwegian language settings, so the functions are in norwegian. AND() will be OG(). I get the same error using both.
- Riny_van_EekelenPlatinum 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.