CODEWITHSUNDEEP
excelexcel-formula
Petermonteer
Petermonteer

Reputation: 336

Conditional formatting formula error

I was following the tutorial on this page to do some conditional formatting, but I'm getting an error when using this formula

=AND ($B3>=45, $B3<=54)

Error message:

enter image description here

It says there is a problem with the formula, and it explains if it starts with an = or - sign it means it's a formula... The information on the error doesn't say anything helpful. Not used to work on excel so sorry if this is stupid. Can you help me? Thanks

Upvotes: 3

Views: 578

Answers (2)

IQV
IQV

Reputation: 500

Obviously you use a localized excel. So in conditional formatting you have to use the localized function names. When using E() instead of AND() it should work.

And as CallumDA mentioned in the comments you should prove which list separator you have to use in your formulas: ; or ,.

Upvotes: 2

CallumDA
CallumDA

Reputation: 12113

Firstly, try changing your comma , to a semicolon ;. 

=AND($B3>=45; $B3<=54)

As pointed out by IQV, you will also need to use the Portugese version of AND() which is E():

=E($B3>=45; $B3<=54)

Here is a source for translating English functions to Portugese functions:
http://dolf.trieschnigg.nl/excel/index.php?langids=en+po

Your regional settings determine whether you need to use a comma or semicolon as a separator. So, when you find formulas with commas in future you'll need to make the same changes again.

You could also change your list separator in your control panel. Go to Clock, Language and Region > Region and Language > Additional settings > List separator and change it from ; to ,.

For more details, see here:
http://datapigtechnologies.com/blog/index.php/why-your-version-of-excel-only-accept-semicolons-in-formulas-instead-of-commas/.

Upvotes: 5

Related Questions