can you use words in conditional formatting?

Yes, but only an exact word

ie: and

NOT

John and Mary

to ensure that your or other users only use exact words (as even a trailing space wouldn't work) use it in combination with data --> validation which can supply a little pulldown list of text to choose from.

Data validation is also useful for other times when words must be very exact, like with SumIf.

Thanks for that Louise

Microsoft Excel training