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