Conditional Formatting – shade all cells in row

[Mary Ann]

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

 

[Bob Phillips]

Change it to =$D2="North"

--
HTH

Bob

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

 

[JE McGimpsey]

One way


use =$D2="North"

 

[Gord Dibben]

Select A2500 then

=$D2="North"

Note the $ sign to "fix" column D


Gord Dibben MS Excel MVP

 

[Mary Ann]

Of course! Thanks all

Select A2500 then

=$D2="North"

Note the $ sign to "fix" column D


Gord Dibben MS Excel MVP