Colours

Y

Yottie

Is it possible to change the colour of an adjacent cell from another
cell which has CF? Without using the words or letters from the second
cell? Just recolour the second cell from the first. And leaving the
second cell info intact?
So if A1 is green (CF) then B1 changes to green but all info remains the
same as before within each cell..
Thanks to all Bill
 
D

David Biddulph

Yes.
If your CF for A1 is set using "Formula is", make sure that column
references in the formula are absolute references, then you can copy the
formatting from A1 to B1.
If your CF for A1 is set using "Cell value is", then you'll need to derive
an equivalent "Formula is" for B1, looking at the value in A1.
 
Y

Yottie

David said:
Yes.
If your CF for A1 is set using "Formula is", make sure that column
references in the formula are absolute references, then you can copy the
formatting from A1 to B1.
If your CF for A1 is set using "Cell value is", then you'll need to derive
an equivalent "Formula is" for B1, looking at the value in A1.
Click to expand...

Thank you David I will try that. Bill
 
Top