I've tried using the following code or more than three conditional formats, but it doesn't work

Basically I want the background color to show red, green, yellow, or blue if the text in a cell says the same thing

"Red" text would = red backgroun
"Blue" text = blue backgroun

Any hints you can give me would be much apprepriated - Thank

***** - five stars to anyone willing to give some feedbac

Private Sub Worksheet_Calculate(
Dim oCell As Rang
For Each oCell In Range("BF261:BF276"
Select Case oCell.Valu
Case Is = Re
oCell.Interior.Pattern = xlColorIndexNon
oCell.Interior.PatternColorIndex =
Case Is = Blu
oCell.Interior.Pattern = xlColorIndexNon
oCell.Interior.PatternColorIndex =
Case Is = Gree
oCell.Interior.Pattern = xlColorIndexNon
oCell.Interior.PatternColorIndex =
Case Is = Ambe
oCell.Interior.Pattern = xlColorIndexNon
oCell.Interior.PatternColorIndex =
Case Is = Complet
oCell.Interior.Pattern = xlColorIndexNon
oCell.Interior.PatternColorIndex = 3
End Selec
Next oCel
End Su