| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing certain text within a cell
I make a production schedule on a daily basis and it has anywhere from 60-120 SKU's per day. I am running into the problem of having too many SKU's that are similar to eachother within one cell. This makes it hard for me to double check my schedule without looking very closely at each letter. A1 would contain this TBLUE(50) THMBLU(60) THBLU(10) THMBLU(47) Is there a formula I could use to color the prefix "THM" blue? I could then make the prefix "TH" a different color etc etc.. I want to avoid doing this manually as it would be quite time consuming for 120 SKU's. -- Brad1982 ------------------------------------------------------------------------ Brad1982's Profile: http://www.excelforum.com/member.php...o&userid=15690 View this thread: http://www.excelforum.com/showthread...hreadid=526815 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you keep text from one cell showing over the next cell? | Excel Discussion (Misc queries) | |||
| Shade cell according to text? | Excel Discussion (Misc queries) | |||
| edit number in cell without it changing to text | Excel Discussion (Misc queries) | |||
| On click, copy text into another cell - XL2K | Excel Worksheet Functions | |||
| Why is my text changing to pound signs? | Excel Discussion (Misc queries) | |||
Threaded Mode
