LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 48
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
2007 Excel conditional formating, reference cell containing specif Lostinthought Excel Discussion (Misc queries) 1 May 16th 08 12:41 AM
Can I include a picture in a formula i.e. if cell a26 >90% then s. PACF Excel Discussion (Misc queries) 24 December 6th 07 10:29 PM
How do I include TEXT in the same cell with a FORMULA? NJCHAZ Excel Discussion (Misc queries) 2 June 21st 07 05:39 PM
Cell Formating in VLookup formula Mike Lindsay Excel Worksheet Functions 3 May 4th 06 02:58 AM
how to include a cell reference that is contained in a cell withi. dutchinny Excel Worksheet Functions 5 October 24th 05 01:07 AM


All times are GMT +1. The time now is 12:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"