Make sure in the formula you use the cell reference as B1 (relative
referencing) and not as $B$1 (absolute referencing)

Below are the different reference styles.
A1 Relative referencing. Both column and row will change if you copy or drag
the formula.
$A1 The column reference is fixed and will not change
A$1 The row reference is fixed and will not change.
$A$1 Column and row reference are fixed.

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Conditional formatting automatically assigns the CF formula to all the cells
within the seleciton. Select the cell/Range (say B1:B10). Please note that
the cell reference B1 mentioned in the formula is the active cell in the
selection. Active cell will have a white background even after selection

If this post helps click Yes
---------------
Jacob Skaria


"gootroots" wrote:

This surly is a simple question with a equally simple answer.

B1:B10 require the following formula:

=B1=True
=B2=True
=B3=True
and so on

when I format B1 and fill down the B1 is still referenced