How can I make a format to follow the cell

  • Thread starter Thread starter Darren
  • Start date Start date
D

Darren

A1 contains 5 with red background.
If I type in another cell, "=A1" then how can I force the new cell to show
the 5 in red background?
 
A formula can only return a result, not a format.

If that red background is the result of conditional formatting,
however, you can apply the same CF rules to the destination cell to
get the same effect.

Hope this helps.

Pete
 
Thanks mate - so I guess I just have to keep writing macro after macro to get
over the short comings of Excel :-)
 

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

Red cell for negative numbers in Excel 1
Change Color of cell 3
Cell Coloring 1
Changing Background Color as a True/False Response 1
protect cell format 1
Copying conditional formating 2
Conditional Formatting 1
Conditional Formating - formula not working 11

Back
Top