Use an absolute reference by placing dollar signs around the cell reference.
i.e. $A$2.

--
Regards,
Dave


"bronek" wrote:


Hello,

I am trying to get an entire row's background colour to change in Excel
based on the value of one cell in its column. I can get this to work
for one cell at a time by using conditional formatting. Is there way
to get this to work for multiple cells and rows, whether with or
without conditional formatting?

Cheers

Bronek


--
bronek
------------------------------------------------------------------------
bronek's Profile: http://www.excelforum.com/member.php...o&userid=27016
View this thread: http://www.excelforum.com/showthread...hreadid=436209