You don't state which cells you are attempting to conditionally format, whether a column or columns, row or rows, or the entire worksheet.
The following example will evaluate the entire worksheet and highlight all cells containing any of the key words. Change the example keywords to your keyword list, adding additional required entries separated by commas.
Copy the following event handler to the clipboard:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
For Each cell In ActiveSheet.UsedRange
Select Case cell.Text
Case Is = "red", "white", "blue", "yellow"
cell.Interior.ColorIndex = 34
Case Else
cell.Interior.ColorIndex = xlNone
End Select
Next
End Sub
Select the worksheet you wish to conditionally format and right click the sheet tab.
Select 'View Code'.
Paste the event handler into the white editing area to the right.
Close the VBE ane return to the worksheet.
Select any cell.
======================
Now, if you want to format cells that contain additional text in addition to the key words, you can use this event handler instead. Change the keywords to your list, and add additional 'Or' sets for additional keywords.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
For Each cell In ActiveSheet.UsedRange
If InStr(UCase(cell.Text), "RED") Or InStr(UCase(cell.Text), _
"WHITE") Or InStr(UCase(cell.Text), "BLUE") Or _
InStr(UCase(cell.Text), "YELLOW") Then
cell.Interior.ColorIndex = 34
Else
cell.Interior.ColorIndex = xlNone
End If
Next
End Sub