software

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 quot;THMquot; blue? I could
then make the prefix quot;THquot; 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: www.excelforum.com/member.php...oamp;userid=15690
View this thread: www.excelforum.com/showthread...hreadid=526815This is very easy if you use VBA:

Sub only_blue()
Dim L As Long
For L = 1 To 100
If Left(Cells(L, 1).Value, 3) = quot;THMquot; Then
Cells(L, 1).Characters(Start:=1, Length:=3).Font.ColorIndex = 5
End If
Next L
End Sub

This little program runs down the first 100 cells in column A and, if they
start with THM, will make the THM blue.

You can adjust the limits to suit your needs.
--
Gary's Studentquot;Brad1982quot; wrote:

gt;
gt; I make a production schedule on a daily basis and it has anywhere from
gt; 60-120 SKU's per day. I am running into the problem of having too many
gt; SKU's that are similar to eachother within one cell. This makes it hard
gt; for me to double check my schedule without looking very closely at each
gt; letter.
gt;
gt; A1 would contain this
gt; TBLUE(50)
gt; THMBLU(60)
gt; THBLU(10)
gt; THMBLU(47)
gt;
gt; Is there a formula I could use to color the prefix quot;THMquot; blue? I could
gt; then make the prefix quot;THquot; a different color etc etc.. I want to avoid
gt; doing this manually as it would be quite time consuming for 120 SKU's.
gt;
gt;
gt; --
gt; Brad1982
gt; ------------------------------------------------------------------------
gt; Brad1982's Profile: www.excelforum.com/member.php...oamp;userid=15690
gt; View this thread: www.excelforum.com/showthread...hreadid=526815
gt;
gt;

That only works if there is a single string in the cell:

A1 = THMBLU(20)

gt;gt; A1 would contain this
gt;gt; TBLUE(50)
gt;gt; THMBLU(60)
gt;gt; THBLU(10)
gt;gt; THMBLU(47)

Biff

quot;Gary''s Studentquot; gt; wrote in message
...
gt; This is very easy if you use VBA:
gt;
gt; Sub only_blue()
gt; Dim L As Long
gt; For L = 1 To 100
gt; If Left(Cells(L, 1).Value, 3) = quot;THMquot; Then
gt; Cells(L, 1).Characters(Start:=1, Length:=3).Font.ColorIndex = 5
gt; End If
gt; Next L
gt; End Sub
gt;
gt; This little program runs down the first 100 cells in column A and, if they
gt; start with THM, will make the THM blue.
gt;
gt; You can adjust the limits to suit your needs.
gt; --
gt; Gary's Student
gt;
gt;
gt; quot;Brad1982quot; wrote:
gt;
gt;gt;
gt;gt; I make a production schedule on a daily basis and it has anywhere from
gt;gt; 60-120 SKU's per day. I am running into the problem of having too many
gt;gt; SKU's that are similar to eachother within one cell. This makes it hard
gt;gt; for me to double check my schedule without looking very closely at each
gt;gt; letter.
gt;gt;
gt;gt; A1 would contain this
gt;gt; TBLUE(50)
gt;gt; THMBLU(60)
gt;gt; THBLU(10)
gt;gt; THMBLU(47)
gt;gt;
gt;gt; Is there a formula I could use to color the prefix quot;THMquot; blue? I could
gt;gt; then make the prefix quot;THquot; a different color etc etc.. I want to avoid
gt;gt; doing this manually as it would be quite time consuming for 120 SKU's.
gt;gt;
gt;gt;
gt;gt; --
gt;gt; Brad1982
gt;gt; ------------------------------------------------------------------------
gt;gt; Brad1982's Profile:
gt;gt; www.excelforum.com/member.php...oamp;userid=15690
gt;gt; View this thread:
gt;gt; www.excelforum.com/showthread...hreadid=526815
gt;gt;
gt;gt;
You are correct Biff:

If ther are multiple strings within A1 containing THM, then the code would
update only the leading instance. In that case:

1. copy the material to a Word doc.
2. use find/replace in Word to change THM into THM (blue)
3. copy the material back into Excel

--
Gary's Studentquot;Biffquot; wrote:

gt; That only works if there is a single string in the cell:
gt;
gt; A1 = THMBLU(20)
gt;
gt; gt;gt; A1 would contain this
gt; gt;gt; TBLUE(50)
gt; gt;gt; THMBLU(60)
gt; gt;gt; THBLU(10)
gt; gt;gt; THMBLU(47)
gt;
gt; Biff
gt;
gt; quot;Gary''s Studentquot; gt; wrote in message
gt; ...
gt; gt; This is very easy if you use VBA:
gt; gt;
gt; gt; Sub only_blue()
gt; gt; Dim L As Long
gt; gt; For L = 1 To 100
gt; gt; If Left(Cells(L, 1).Value, 3) = quot;THMquot; Then
gt; gt; Cells(L, 1).Characters(Start:=1, Length:=3).Font.ColorIndex = 5
gt; gt; End If
gt; gt; Next L
gt; gt; End Sub
gt; gt;
gt; gt; This little program runs down the first 100 cells in column A and, if they
gt; gt; start with THM, will make the THM blue.
gt; gt;
gt; gt; You can adjust the limits to suit your needs.
gt; gt; --
gt; gt; Gary's Student
gt; gt;
gt; gt;
gt; gt; quot;Brad1982quot; wrote:
gt; gt;
gt; gt;gt;
gt; gt;gt; I make a production schedule on a daily basis and it has anywhere from
gt; gt;gt; 60-120 SKU's per day. I am running into the problem of having too many
gt; gt;gt; SKU's that are similar to eachother within one cell. This makes it hard
gt; gt;gt; for me to double check my schedule without looking very closely at each
gt; gt;gt; letter.
gt; gt;gt;
gt; gt;gt; A1 would contain this
gt; gt;gt; TBLUE(50)
gt; gt;gt; THMBLU(60)
gt; gt;gt; THBLU(10)
gt; gt;gt; THMBLU(47)
gt; gt;gt;
gt; gt;gt; Is there a formula I could use to color the prefix quot;THMquot; blue? I could
gt; gt;gt; then make the prefix quot;THquot; a different color etc etc.. I want to avoid
gt; gt;gt; doing this manually as it would be quite time consuming for 120 SKU's.
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; Brad1982
gt; gt;gt; ------------------------------------------------------------------------
gt; gt;gt; Brad1982's Profile:
gt; gt;gt; www.excelforum.com/member.php...oamp;userid=15690
gt; gt;gt; View this thread:
gt; gt;gt; www.excelforum.com/showthread...hreadid=526815
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;