Conditional Formating with multiple conditions (1 Viewer)

[Edgarr8]

HI

I have a cell that i would like to get it highlighted if the value was not "12" or "24"...I have
Field Value is not equal to 24 in my first condition
but i cannot put
Field calie is not equal 12 in my second condition because it highlight everything...

So i tried putting and "or" between and nothing..

this is probably something really easy...please guide me..

 

[pbaldy]

Try

[FieldName] <> 12 AND FieldName <> 24

 

[missinglinq]

Paul forgot the square brackets around the second FieldName and they are required in Conditional Formatting.

 

[pbaldy]

That I did and that they are.

 

[Edgarr8]

Alright!
Thank you guys a lot...

In case anybody else needs something similar in the conditional formatting
you have to go into Expression is and then your criteria..

It makes so much sense now...