Multiple conditions

[jeremywessels70]

Hi guys, I need help applying conditional formatting to a large range of cells.
Condition 1: If the number is an even number and lower than 25, fill cell yellow
Condition 2: If the number is an odd number and lower than 25, fill cell blue
Condition 3: If the number is an even number and higher than 25, fill cell grey
Condition 2: If the number is an odd number and higher than 25, fill cell green

Is it possible to apply all these conditions in one formula in conditional formatting, or what would be the easiest way of going about this?

Thanks!

 

[Fluff]

Hi & welcome to MrExcel.
You will need to create a rule for each colour.

 

[jeremywessels70]

Hi & welcome to MrExcel.
You will need to create a rule for each colour.

Hi, thanks for the quick response. Could you give me an example of how it would look?

 

[Fluff]

What should happen if the cell is 25?
Also could you have blank cells & if so should they be ignored?

 

[jeremywessels70]

What should happen if the cell is 25?
Also could you have blank cells & if so should they be ignored?

Formula should be <=25 and even then fill cell yellow.

There are no blank cells in the range

 

[Fluff]

Ok, how about

+Fluff New.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1
2	40	37	37	19	35	24	36	37	6	16
3	34	42	16	7	23	6	31	50	28	24
4	39	3	40	23	11	15	9	38	50	37
5	11	48	25	1	25	11	3	50	43	14
6	30	15	8	21	44	32	2	15	28	31
7	24	14	49	29	22	2	46	2	42	33
8	47	38	26	22	34	37	35	23	26	30
9	38	45	39	36	14	26	12	27	10	29
10	41	46	13	28	36	15	14	37	13	5
11	14	8	16	29	12	24	47	37	40	19
12
Lookup

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:J11	Expression	=AND(A2>25,ISODD(A2))	text	NO
A2:J11	Expression	=AND(A2>25,ISEVEN(A2))	text	NO
A2:J11	Expression	=AND(A2<=25,ISODD(A2))	text	NO
A2:J11	Expression	=AND(A2<=25,ISEVEN(A2))	text	NO

 

[jeremywessels70]

So simple ? you are awesome, thanks

 

[Fluff]

You're welcome & thanks for the feedback.