Changing Colour of cell if certain word appears

[philb99]

Hi - is there anyway of changing the background colours of a cell if a certain word appears in the cell, ie South (Yellow background) North (red background)

Thanks

 

[Joe4]

You can use Conditional Formatting for that.
Just select the cells to be included in this consideration, go to "Conditional Formatting" and select the "Format only cells that contain" rule and fill it put like shown below:

 

[philb99]

You can use Conditional Formatting for that.
Just select the cells to be included in this consideration, go to "Conditional Formatting" and select the "Format only cells that contain" rule and fill it put like shown below:
View attachment 118440

Thanks

 

[Joe4]

You are welcome.
Glad I was able to help!