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

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.
--
David Biddulph

"Yottie" wrote in message
...
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

David Biddulph wrote:
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.

Thank you David I will try that. Bill