You would probably be better off to start your own thread and give exact details!! What Words? What Cells? What version of Excel?? For versions earlier than 2007, you may need code depending on how many different formats you have!!I have a similar question and being new I'm not sure if I should post it here or start a new thread. Sorry if I am in the wrong place.
I want to change the color of words in certain cells (or sometimes all the cells) in a row depending on the value entered in a particular cell.
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address <> "$A$1" Then Exit Sub Cells.Interior.ColorIndex = xlNone Select Case UCase(Target) Case "FTP": Range("Range1").Interior.Color Index = 15 Case "XXX": Range("Range2").Interior.ColorIndex = 15 'etc Case Else: End Select End Sub