Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying Cell Contents in Another Workshheet Based on Formatting
Using Excel 2003.
I have a list of names in a range of cells, one name in the range is formatted as italic. Is it posbile to have the italicized name in the range be displayed in another worksheet based on the fact it is formatted differently (italics) than the other cells in the range? Thank you in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying Cell Contents in Another Workshheet Based on Formatting
Mark
Not exactly, but if you can use conditional formatting on your original data to italicize it, you can use the same criteria to show it on another sheet using an IF function. But if this is just manually italicized, then no, but if you think carefully, there will be a reason why you italicize the cell. e.g if after a certain date or over a certain value, etc. These can all be conditionally formatted and also displayed on another sheet based on a criteria -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk UK Excel User Conference In Cambridge November 28th - December 1st 2007 Register Now @ http://www.exceluserconference.com/UKEUC.html "Mark Watlock" wrote in message ... Using Excel 2003. I have a list of names in a range of cells, one name in the range is formatted as italic. Is it posbile to have the italicized name in the range be displayed in another worksheet based on the fact it is formatted differently (italics) than the other cells in the range? Thank you in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting one cell based on the contents of another | Excel Discussion (Misc queries) | |||
Formatting one cell based on the contents of another cell | Excel Worksheet Functions | |||
Formatting one cell based on the contents of another | Excel Discussion (Misc queries) | |||
Help with displaying the contents of the last populate cell. | New Users to Excel | |||
Displaying cell contents on one sheet | Excel Discussion (Misc queries) |