conditional Formatting

[mustu2]

Hi

I am trying to use a conditional formatting with a criteria of more than one numbers, but dont know how.

For instance; "Format only cell that contains"

100 and 101 and 102

it works alright for one number, but what criteria should i give for more than one number?

Thanks in advance

 

[VoG]

Try with a CF formula like

=OR(A1=100,A1=101,A1=102)

 

[T. Valko]

Hi

I am trying to use a conditional formatting with a criteria of more than one numbers, but dont know how.

For instance; "Format only cell that contains"

100 and 101 and 102

it works alright for one number, but what criteria should i give for more than one number?

Thanks in advance

What version of Excel are you using?

Use the "formula option" and use a formula like this:

=OR(A1=100,A1=101,A1=102)

Replace A1 with the actual cell reference.

 

[mustu2]

Its not working, the Formula i have given is

=OR(A:A=100,A:A=101,A:A=102)

i am using 2007

Thanks

 

[VoG]

No, you need to select from A1 to the end of your data then use the CF formula given above.

 

[mustu2]

nopes

=OR($A$1:$A$7=100,$A$1:$A$7=101,$A$1:$A$7=102)

its highlighting the whole range even if it does not include the criteria numbers, for instance if the number is 103, it is also highlighting 103.

 

[VoG]

Select A1:A7. Apply this CF formula

=OR(A1=100,A1=101,A1=102)

 

[T. Valko]

nopes

=OR($A$1:$A$7=100,$A$1:$A$7=101,$A$1:$A$7=102)

its highlighting the whole range even if it does not include the criteria numbers, for instance if the number is 103, it is also highlighting 103.

Tell us what version of Excel you're using and tell us the EXACT range of cells you want to format.

 

[mustu2]

Thanks a ton, its working!!

Again Thank you!!

Genius guys in the forum