cell colour

G

Guest

In a workbook i use i have a cell that has the following formula so it stays
the same value as another cell e.g.

=sheet2!$B$1

No problem. But what formula can i use so that the cell has the same value
and colour?, if i change the colour of the cell B2 i want the colour to
automatically change in the other cell.
Thanks
 
B

Bernard Liengme

A formula can only change the VALUE that is displayed; it cannot change the
format. You would need some VBA code to do that.
best wishes
 
B

Bob I

Use conditional formatting to set the cell color, and use the same
expression in both cells.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting in Excel 2010 2
Remove colour change 4
Changing coloue cell en text colour by clicking cell 3
Conditional Formatting - Excel 2003 2
format cells depending on value range 5
Using CF to change colour in cell based on date? 4
Highlighting cell on value difference. 1
get cell to automatically change colour depending on text in adja. 1

Top