I'm trying to have the color of a cell change if a string of text appears in any of several other columns.

For example:

A4: Don
Conditionally Format A4 to change to yellow if "Awaiting Action" appears in any of the columns K4-N4.

I keep trying =A4($K4:$N4="Awaiting Action") and nothing happens. I've tried a few iterations of this and still nothing or I get a "Hey dummy this isn't a formula, maybe you want this to be only text" error.

This also needs to be able to retain its formatting after being linked into a powerpoint. And If there is an easy way to Copy and Paste this formatting to other cells so someone other than me can just add the info and have it update automatically instead of letting someone else mess with the formatting and screw it up later?

Thanks. I've been pulling my hair out for the last 4 hours trying to figure this one out. My newly receding hairline and I appreciate your help.

FTFTRACKER 2.xlsx