Conditional format

[Guest]

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

 

[Guest]

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

 

[Frank Kabel]

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

 

[Frank Kabel]

Hi
no, this is possible with CF )

 

[Guest]

hi Frank

nice one, worked a treat,

cheers Rexmann