Forum Discussion

Mel5t's avatar
Mel5t
Copper Contributor
Aug 03, 2023

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_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    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.

     

Resources