Formula with multiple conditions

[Boyan Boyanov]

I want cells data in column B to color green if colum A fulfills some of these conditions (in table below).
For example if SIZE is greater than 4B in cell A1 and GROWTH is greater than 5% in cell B1 then cell B1 to be in green or if A1 is between 0.4B and 4B and cell B1 is 7% or more then cell B1 to be colored green or if data in A1 is less than 0.4B and in B1 percentage is more than 12%, then B1 to colored green.


Many thanks in advance!

	SIZE	GROWTH
	>4B	5%
	>0.4B<4B	7%
	<0.4B	12%

<tbody>
</tbody>

 

[mikerickson]

Conditional Formatting allows you to set several conditions

 

[oldbrewer]

										MYTABLE1			MYTABLE2
SIZE	GROWTH	COLOR	INFO ONLY
>4	>5%	GREEN	3,B							0.01	1			0.001%	A
>0.4B<4B	>7%	GREEN	2,C							0.4	2			5.001%	B
<0.4B	>12%	GRFEEN	1,D							4.01	3			7.001%	C
										999	3			12.001%	D
					size	growth	COLOUR							999%	D
					5	5.10%	GREEN				MYTABLE3
					4.7	7.10%	0
					4.4	12.10%	0				1A
					4.1	5.10%	GREEN				1B
					3.8	7.10%	GREEN				1C
					3.5	12.10%	0				1D	GREEN
					3.2	5.10%	0				2A
					2.9	7.10%	GREEN				2B
					2.6	12.10%	0				2C	GREEN
					2.3	5.10%	0				2D
					2	7.10%	GREEN				3A
					1.7	12.10%	0				3B	GREEN
					1.4	5.10%	0				3C
					1.1	7.10%	GREEN				3D
					0.8	12.10%	0
					0.5	5.10%	0
					0.4	7.10%	GREEN
					0.3	12.10%	GREEN
					0.2	5.10%	0
					0.15	7.10%	0
					0.1	12.10%	GREEN
		ONCE YOU HAVE SET UP THE 3 LOOKUP TABLES ANY PAIRING CAN BE CHECKED
		FORMULA GIVING THE TOP GREEN NEXT TO 5,5.1%
		=VLOOKUP(VLOOKUP(F14,MYTABLE1,2)&VLOOKUP(G14,MYTABLE2,2),MYTABLE3,2)
		TO SET IT IN THE COND FORMAT BOX JUST ADD ="GREEN" TO THE END OF IT

<colgroup><col width="64" span="17" style="width:48pt"> </colgroup><tbody>
</tbody>