I have a list with column headings e.g. Code, Value, Description, Category.
Lets say the headings y are in A1 to A4 with my list going down to row 500. I
want to shade all cells in a row if the value in the Category column is, for
example, North.

I have selected the whole range, excluding the headings, Format, Conditional
Formatting. Then selected Formula Is and typed =D2=€�North€� and then selected
a pattern colour via the Format button.

Unfortunately this only shades the entries in column A.

I have managed to achieve what I want in the past but cant quite remember
how to do it!

I am using Excel 2003