LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Phyllis
 
Posts: n/a
Default Color a single digit in a mult-digit number cell

Suggestion for Microsoft

I would like to be able to format a single digit in a number cell that
contains 2 or more digits. For example, if I type 346 in a cell, I would like
to be able to bold or color just one of the digits, say the 3. The reason:
to help me test a theory. If the solution to a problem could be either a 3,
4, or 6 in a given cell, I migth want to test the theory that it's the 3. If
I could color the 3 in the cell containing 346, and then color the resulting
answer in other cells, I could track all the changes I made to test the
theory without erasing the other possible variables incase my theory is
wrong. Yes, I confess, it's to help me solve a five-star (highest
difficulty) Sudoku puzzle.

Other suggestions for testing a theory without eliminating the variables are
welcome. Programming an IF logic sequence would be too complex. (I've tried
just bracketing the theoretical numbers, but it gets clumsy, confusing and
cumbersome.)
--
PT




--
PT

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc
 
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
How do I copy the last digit of a number from a cell Carlos Excel Discussion (Misc queries) 4 September 29th 05 07:17 PM
Number of characters in a cell (one row, merged columns) Dajana Excel Discussion (Misc queries) 1 September 19th 05 09:30 PM
number cell increment +1 when dragging down box Johnny Cake Excel Worksheet Functions 4 August 18th 05 07:29 PM
Can I make the number in one cell automatically appear elsewhere? holmeshouse Excel Worksheet Functions 2 August 17th 05 01:12 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM


All times are GMT +1. The time now is 03:42 PM.

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"