conditional format

[Kyle]

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]

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

--