I am having a heck of a time finding a way to make this work...
I have a workbook with many sheets in it. One of these sheets is a "Base" sheet where the user fills in a list of names (along with other base information). Now these names may be Bold, Underlined, or in Regular text depending on who it is. The problem sheet is called "Summary" which provides formulas to make all kinds of calculations based off information in these other sheets. For the name column it is just doing a simple "=Base!A10", "=Base!A11", "=Base!A12", and so on. This copies the names automatically as they change in the "Base", which is what I want... but I want the formatting to automatically copy over too. I don't want them to have to run a macro either, I want it automatic.
Also, there is one other column that is just referencing another sheets column (no calculations, just like the names). This column contains either a number or a date (depending on the corresponding person). When a date is inserted into the "Base" it changes the format of the cell to the date type. But when this cell is then referenced in "Summary" it is a general type and so the date is converted to its funky number representation. I would also like it to copy/reference the date type over in this case.
I was thinking I could use conditional formatting which would always be true, but you have to use statically set formats, I couldn't reference a cells format. At least not that I could see.
Any help or ideas on solving this would be great. Thank you very much.
Bookmarks