ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cell formating (https://www.excelbanter.com/excel-discussion-misc-queries/16948-cell-formating.html)

Gerardo

Cell formating
 
If one cell in a spreadsheet has a specific format (font, color, etc..) and I
have another cell that will equal that cell with an if formula, how do I
retain the formatting of the original cell in the cell with the result?

Biff

Hi!

You would have to do that through conditional formatting
or manually format the cell with the formula in it.

A formula will only return a value from another cell and
not that other cells formatting.

Biff

-----Original Message-----
If one cell in a spreadsheet has a specific format (font,

color, etc..) and I
have another cell that will equal that cell with an if

formula, how do I
retain the formatting of the original cell in the cell

with the result?
.



All times are GMT +1. The time now is 03:58 PM.

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