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? |
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