Conditional formatting (vba)

[tsitsicat1]

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

A	B	C	D	E	F
A/A	name	ΠΕΡΙΟΧΗ	ΤΚ	REP	FOCUS
41308	ALBERT NAME	ATHENS	33051	109	1
21776	KONSTANT NAME	ATHENS	35001	109	2
38235	TSAPROS NAME	LAMIA	35002	109	3
40982	ANESTOS	LAMIA	35004	109	4
35287	MATSOS NAME	MIKONOS	35004	109	4

<tbody>
</tbody>

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