Mass formatting issues

[chinchi81]

Hi,

I have the below spreadsheet and require to format it depending on what appears in column AE and column N. So for example if in AE it says AAA and the figure in column N is >=-1 and<-1.1, then on that row, cells A to C, J to N & cell AE would change format to a black background and white font.

This would need to happen from rows 3 to 308.

As I have more than 3 conditions, I will need to put this in a macro but am not sure as to how to get it started.

Belgium - Jupiler League.xls
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE
2	Date	Home	Away	FTHG	FTAG	FTR	HTHG	HTAG	HTR	H	D	A	51	Goals	H	D	A	17	Goals	H	D	A	7	Goals	WHH	WHD	WHA	51	17	7
3	03/08/2007	Mechelen	Anderlecht	0	1	A	0	0	D				A	-1.02				A	-2.18				A	-1.71	5.5	3.5	1.53	4.5	4.5	4.5	AAA
4	04/08/2007	Charleroi	Roeselare	1	1	D	1	0	H									H	2.00				H	3.29	1.62	3.4	5	-1	-1	-1	HH
5	04/08/2007	ClubBrugge	Bergen	2	1	H	1	1	D				H	2.65				H	2.47				H	2.00	1.36	4	7.5	0.36	0.36	0.36	HHH
6	04/08/2007	Dender	Germinal	1	2	A	0	0	D																2.88	3.2	2.2	-1	-1	-1
7	04/08/2007	FCBrussels	Westerlo	0	1	A	0	0	D				A	0.76				D	0.94				H	1.71	2.2	3.2	2.88	1.2	-1	-1	ADH
8	04/08/2007	Genk	CercleBrugge	3	1	H	3	1	H				H	2.31				H	2.24				D	1.00	1.33	4	8.5	0.33	0.33	-1	HHD
2007-2008

 

[Tank997]

Smitty,

I am not intinadated by asking questions, just answering them.

You and many others here, know far more than I will ever know about VBA, and how to do certian things.

I only wish, I knew how to write code in VBA without using the record function!