colour cell (s) based on ...

[Trevor3007]

Hi,

I have row ( e16:AJ16) and I need some VB so if a cell , or cells contain a certain word , it/they will change colour to blue?

elow is what I have to use & the red grided area is where I would like to apply the code.
please can someone with the knowledge please provide?
Thank you kind coders.

 

[etaf]

do you need VBA , or will conditional formatting work ?
select
e16:AJ16
then apply conditional formatting - formula
E16="certain word"
format blue

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>

e16:AJ16
Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=E16="certain word"
Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

i do not provide VBA , so if really need VBA , other members should help

 

[Trevor3007]

do you need VBA , or will conditional formatting work ?
select
e16:AJ16
then apply conditional formatting - formula
E16="certain word"
format blue

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>

e16:AJ16
Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=E16="certain word"
Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

i do not provide VBA , so if really need VBA , other members should help

thank you,,, yes thay does work, but , I need to use on 12 worksheets (jan - dec) and using con formating, I wil have to do on each sheet.

Thank you any hoos :}