Conditional format
 

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

that situation is a bit beyond what conditional formating
is about. sorry. you would have to use code to do that.

-----Original Message-----
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
.

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

Hi
no, this is possible with CF :-))

--
Regards
Frank Kabel
Frankfurt, Germany

schrieb im Newsbeitrag
...
that situation is a bit beyond what conditional formating
is about. sorry. you would have to use code to do that.

-----Original Message-----
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
.

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