Conditional formatting (vba)

[tsitsicat1]

Hey there!!
I have a problem with my worksheet.

[TABLE="width: 746"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]A/A[/TD]
[TD]name[/TD]
[TD]ΠΕΡΙΟΧΗ[/TD]
[TD]ΤΚ[/TD]
[TD]REP[/TD]
[TD]FOCUS[/TD]
[/TR]
[TR]
[TD]41308[/TD]
[TD]ALBERT NAME[/TD]
[TD]ATHENS[/TD]
[TD]33051[/TD]
[TD]109[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]21776[/TD]
[TD]KONSTANT NAME[/TD]
[TD]ATHENS[/TD]
[TD]35001[/TD]
[TD]109[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]38235[/TD]
[TD]TSAPROS NAME[/TD]
[TD]LAMIA[/TD]
[TD]35002[/TD]
[TD]109[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]40982[/TD]
[TD]ANESTOS[/TD]
[TD]LAMIA[/TD]
[TD]35004[/TD]
[TD]109[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]35287[/TD]
[TD]MATSOS NAME[/TD]
[TD]MIKONOS[/TD]
[TD]35004[/TD]
[TD]109[/TD]
[TD]4[/TD]
[/TR]
</tbody>[/TABLE]

I would like to color the row
from A to F if 1 with green
from A to F if 2 with blue
from A to F if 3 with orange
from A to F if 4 with red

Can you help me please?
Thanks in advance

 

[Jeffrey Mahoney]

* Highlight all your data from A2:F1000 or whatever row it ends on.
* Start a new conditional format - Use a formula to determine the cell format
* Type: =$F2=1
* Choose the format to fill with green

Do the same thing for the other colors but type: =$F2=2 for blue.... and so on

Jeff