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.
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 |