Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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? |
#2
![]() |
|||
|
|||
![]()
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? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional formating for a blank cell | Excel Discussion (Misc queries) | |||
Copy cell formating as part of a formula | Excel Worksheet Functions | |||
Conditional formating - cell protection | Excel Discussion (Misc queries) | |||
cell formating based on value | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |