Conditional Formatting Colour in a Results Table

[90sDave]

Hi guys, I am fairly new to doing VBA coding stuff so if my question seems a bit obvious, that's why.

I am trying to do a results table for football like this:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Team 1
[/TD]
[TD]Team 2
[/TD]
[TD]Team 3
[/TD]
[TD]Team 4
[/TD]
[/TR]
[TR]
[TD]Team 1
[/TD]
[TD][/TD]
[TD]2-1
[/TD]
[TD]0-3
[/TD]
[TD]2-2
[/TD]
[/TR]
[TR]
[TD]Team 2
[/TD]
[TD]1-0
[/TD]
[TD][/TD]
[TD]1-2
[/TD]
[TD]0-0
[/TD]
[/TR]
[TR]
[TD]Team 3
[/TD]
[TD]4-1
[/TD]
[TD]2-0
[/TD]
[TD][/TD]
[TD]2-0
[/TD]
[/TR]
[TR]
[TD]Team 4
[/TD]
[TD]2-1
[/TD]
[TD]1-1
[/TD]
[TD]0-2
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I am trying to format the cells so that if the left hand number is bigger than the right, the cell colours green. If the right is bigger the cell colours red and if they are the same, yellow.
I have tried a few different ways to do this and it hasn't worked. I've also looked on the internet and can't find anything.
I am doing this in Excel 2010.
Can anyone help me out?
Thanks

 

[Momentman]

Highlight the cells starting from cell B2 and use 3 formulas like this
1. =IF(B2="","",1*LEFT(B2,FIND("-",B2)-1)>1*RIGHT(B2,LEN(B2)-FIND("-",B2)))=TRUE - choose to format with GREEN
2. =IF(B2="","",1*LEFT(B2,FIND("-",B2)-1)>1*RIGHT(B2,LEN(B2)-FIND("-",B2)))=FALSE -Choose to format with RED
3. =IF(B2="","",1*LEFT(B2,FIND("-",B2)-1)=1*RIGHT(B2,LEN(B2)-FIND("-",B2)))=TRUE -Choose to format with YELLOW

You should have the results like below

Excel 2010
	A	B	C	D	E
1		Team 1	Team 2	Team 3	Team 4
2	Team 1		2-1	0-3	2-2
3	Team 2	1-0		1-2	0-0
4	Team 3	4-1	2-0		2-0
5	Team 4	2-1	1-1	0-2
Sheet2

 

[90sDave]

Hi,
Thanks for the help, but I was looking for a way to do it with VBA coding and this won't do that.

 

[Momentman]

Any particular reason why it has to be VBA?

 

[GerryZ]

@momentman
Woooowww! very good job.. i like this trick, i didn't know conditional formatting could do such a good things

 

[Momentman]

I think the second formula should be this instead =IF(B2="","",1*RIGHT(B2,LEN(B2)-FIND("-",B2))>1*LEFT(B2,FIND("-",B2)-1))=TRUE - format as Red