Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula with Cell reference to include formating?
I would like it to display the results of a cell formula in the same format
that is in the referenced cell. For instance (simplified): Cell A1 is formatted in Bold and Red. Cell A2 is formatted in Italics and Blue. The formula in B1 is =Max(a1:a2) Then B1 would display in Bold and Red if A1 was the higher of the two numbers but in Italics and Blue if A2 was the higher. Is there a way to do this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Excel conditional formating, reference cell containing specif | Excel Discussion (Misc queries) | |||
Can I include a picture in a formula i.e. if cell a26 >90% then s. | Excel Discussion (Misc queries) | |||
How do I include TEXT in the same cell with a FORMULA? | Excel Discussion (Misc queries) | |||
Cell Formating in VLookup formula | Excel Worksheet Functions | |||
how to include a cell reference that is contained in a cell withi. | Excel Worksheet Functions |