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 response

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