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: 1
Default Multiple Colors (at the same time) in a cell with a formula


I'm trying to make a date stand out in a cell.
My Cell should read as follows:

Estimate Complete In August


"August" or "In August" if need be is taken from another cell.

="Estimate Complete In "&A1
is a basic representation of how my formula bar displays.

I've tried Custom Cell formating, but that seems to default only to one
color, or show an error.

Any and all help would be appreciated.


--
MACRE0
------------------------------------------------------------------------
MACRE0's Profile: http://www.excelforum.com/member.php...o&userid=10848
View this thread: http://www.excelforum.com/showthread...hreadid=572044

 
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
Formula for displaying in 1 cell Lowest value from multiple other cells [email protected] Excel Worksheet Functions 1 March 16th 06 11:07 PM
Formula Problem - interrupted by #VALUE! in other cells!? Ted Excel Worksheet Functions 17 November 25th 05 05:18 PM
Formula is entering a default time when it comes across an empty cell.. Howie Excel Worksheet Functions 10 November 16th 05 11:34 AM
Click in cell w/ formula and get colors in referenced cells albean Excel Discussion (Misc queries) 0 November 11th 05 07:04 PM
Changing a cell referent in a formula several at a time... johnexcel New Users to Excel 3 August 27th 05 05:15 PM


All times are GMT +1. The time now is 12:21 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"