Select cell H1
Select the range you wish to affect, make sure that H1 remains as your
active cell (ie, in the range selected H1 is the odd highlight)
Enter the Format, Conditional Format, Formula and set the format for
Pattern

This should reflect as required

note, the formula is

C1=H1 (goes to C8=H8 etc)
C$1=H1 (goes to C1=H8 etc
C$1=H$1 (goes to C1=H1 on all rows)
C1=H$1 (goes to C8=H1 etc)

Hope this helps

--

Kyle Wrote:
I have 2 columns. C1 & H1. I am using the conditional format ting to
format
column H1 to change color if the value in cell H1 is equal to the value
in
cell C1. how do copy this conditional format down the rest of the cell
in
column H1. I tried to copy and paste down the cell in column H1 but
the
equal value alway reference to C1 cell instead of C2, H2; C3, H3 and so
on..

thx.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=535826