1. 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

2. From menu FormatConditional Formatting
3. For Condition1Select 'Formula Is' and enter the below formula
=A1=TRUE
4. Click Format ButtonPattern and select your color (say Red)
5. Hit OK


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


"gootroots" wrote:

Hi guys,

Thanks for helping out.

Actually I have made a mistake in my previous post

B1:B10 require the following formula:

=A1=True
=A2=True
=A3=True
and so on

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

Sorry for the confusion.

When I examine say B3 the formula references A1

The only value that is true in A1:10 is A1 yet B1:B10 are all formatted with
a fill colour.

Confused!



"Jacob Skaria" wrote:

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