Help with formatting

Closed
JP - Jun 16, 2016 at 04:36 PM
fdibbins
Posts
33
Registration date
Sunday June 19, 2016
Status
Contributor
Last seen
November 20, 2016
- Jun 20, 2016 at 02:35 AM
Hello,

Hi everyone. I am looking to do some conditional formatting and I need some assistance. Can someone please help me to understand how I can format it in a way that highlights the first cell in a row if anywhere in that row a specific word appears?

Thanks in advance!

Jamie


1 reply

fdibbins
Posts
33
Registration date
Sunday June 19, 2016
Status
Contributor
Last seen
November 20, 2016
1
Jun 20, 2016 at 02:35 AM
You could probably use COUNTIF() in the CF as the rule...
=countif(range, "word")>0
0