Aug 02 2023
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.
Aug 03 2023
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.