hi Frank

nice one, worked a treat,

cheers Rexmann

"Frank Kabel" wrote:

Hi
try the following:
- lets assume A1 is the cell and you want to format A1:X1

- select A1:X1
- goto the conditional format dialog.
- enter 'Formula is'
- enter the formula
=$A1=value
- choose your format

--
Regards
Frank Kabel
Frankfurt, Germany

"rexmann" schrieb im Newsbeitrag
...
Hi all

This one might be a bit tricky (or not!). I know how to conditonal
format
but is it possible to use the value in one cell but display the
formatting
in another or alternatively format an entire record but only
referencing one
cell

Example in a database of names and details conditional format the
date of
birth as between sep1973 and Nov1974 - but the formatting would
effect the
whole row or rows.

I thought some kind of IF statement. Alternative is there syntax
which
displays the different value_IF sections?

Any help (even if it is to say it is not possible) is greatly
appreciated

Rexmann