function to change a specific cells range color depending on a text

[jorgefilemon]

hi guys,

what i want to do is to change the color of a specific cells range depending on the text content on the cell column called ubi, so far this is what i have written, i dont know VBA though. im missing how to write the range on the specifi cells I guess.

Function apa()

If (cell.Value = "apa" Or cell.Value = "apa mesa") Then
Range( U?:AJ? ).Interior.Color = RGB(192, 192, 192)
ElseIf (cell.Value = "mesa") Then
Range( U?:AJ?).Interior.Color = RGB(153, 204, 0)
Else
Range( U?:AJ? ).ColorIndex = 0

End function

 

[Nanogirl21]

hi guys,

what i want to do is to change the color of a specific cells range depending on the text content on the cell column called ubi, so far this is what i have written, i dont know VBA though. im missing how to write the range on the specifi cells I guess.

Function apa()

If (cell.Value = "apa" Or cell.Value = "apa mesa") Then
Range( U?:AJ? ).Interior.Color = RGB(192, 192, 192)
ElseIf (cell.Value = "mesa") Then
Range( U?:AJ?).Interior.Color = RGB(153, 204, 0)
Else
Range( U?:AJ? ).ColorIndex = 0

End function

I'd recommend using conditional formatting to change to change the color of text (or the cell) if it contains a specific content.

 

[jorgefilemon]

I'd recommend using conditional formatting to change to change the color of text (or the cell) if it contains a specific content.

i cant make conditional formatting to work this way, as it only changes the colors within the cell where the rule is applied.