Syntax error in conditional formatting while using AND()

[Mel5t]

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.

[#2]

@Mel5t 

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.