Conditional Formatting (If cell value in row column A = 3 or 5 or etc... then cell value B = 1 or 2).

[griffindor2020]

Hello,

I was wondering if I could tell excel to insert a value (1 or 2) along all of column B, based off the values that are in column A.

For example

If A = 1 or 3 or 5 or 6 or etc... Then values in column be should be 1.
and
If A = 2 or 4 or 7 etc... Then values in column B should be 2.

Is there a way to code this ?

I have approximately 100 000 rows of data. I hope someone will be able to help me save some time

Thank you

 

[Fluff]

How many different numbers do you have in col A?

 

[griffindor2020]

How many different numbers do you have in col A?

I have 35 different values (that repeat from A1 down to A+100 000).

 

[Fluff]

Ok, if you want even numbers to be 2 & odd numbers 1, you can use
=ISEVEN(A2)+1
Failing that
either something like
=ISNA(MATCH(A2,{1,3,5,6},0))+1
or create a lookup table of the numbers & what they should return.

 

[griffindor2020]

Hello,

the =ISNA(MATCH, A2, {...},0))+1 function worked out well for me

Thank you

 

[Fluff]

You're welcome & thanks for the feedback.