you need to delete the "$" from the references in the conditional format
formula.

"alex1982" wrote:


I have tried that but its not working how i want it to.
say if cells b2 to e2 are reffering to cell a2. if i copy and paste it
as u suggested cells b3 to e3 are still reffering to a2 not a3 as i was
expecting


--
alex1982
------------------------------------------------------------------------
alex1982's Profile: http://www.excelforum.com/member.php...o&userid=37494
View this thread: http://www.excelforum.com/showthread...hreadid=571516