Syntax error in conditional formatting while using AND()

Copper Contributor



I get an syntax error using the AND()-function in the following formula for conditional formatting:




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.

1 Reply


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.