ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Obtain Cell Formatting in Cell Referencing? (https://www.excelbanter.com/excel-programming/387927-obtain-cell-formatting-cell-referencing.html)

Al Franz

Obtain Cell Formatting in Cell Referencing?
 
When you reference a cells contents in another cell is there anyway to also
bring over such things as the background colors, bold, font, etc?



JE McGimpsey

Obtain Cell Formatting in Cell Referencing?
 
Not with formulae, which can only return values to their calling cells.
You can replace the formula with an event macro that can format the cell
if you wish.

In article ,
"Al Franz" wrote:

When you reference a cells contents in another cell is there anyway to also
bring over such things as the background colors, bold, font, etc?



All times are GMT +1. The time now is 06:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com