Format row in relation to column data

[dallr]

I have some data which is being exported to an excel sheet.

In this sheet there is a column which holds numeric values e.g. (1,2,3,4,5). Depending on the column value I would like the entire row to change color. E.g

1 = Red
2 = Orange
3= green.

How can I achieve this? I am thinking some custom VBA is needed.

 

[VoG]

Depending on your version of Excel (If 2007 or later) you might be able to use Conditional Formatting http://www.contextures.com/xlCondFormat02.html

 

[dallr]

I am using 2003.

 

[VoG]

You only have 3 formats so CF should work.

 

[dallr]

Thanks it worked nicely.

Dane