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

Change it to =$D2="North"

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Mary Ann" wrote in message
...
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 can't quite remember
how to do it!

I am using Excel 2003

One way


use =$D2="North"

In article ,
Mary Ann wrote:

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

Select A2:D500 then

=$D2="North"

Note the $ sign to "fix" column D


Gord Dibben MS Excel MVP

On Wed, 31 Oct 2007 10:31:05 -0700, Mary Ann
wrote:

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 can’t quite remember
how to do it!

I am using Excel 2003

Of course! Thanks all

"Gord Dibben" wrote:

Select A2:D500 then

=$D2="North"

Note the $ sign to "fix" column D


Gord Dibben MS Excel MVP

On Wed, 31 Oct 2007 10:31:05 -0700, Mary Ann
wrote:

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