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
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
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
Related:
- Help with formatting
- How to clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- How to format windows 7 with keyboard - Guide
- Formatting usb mac - Guide
- Code for formatting android phone - Guide
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
Jun 20, 2016 at 02:35 AM
You could probably use COUNTIF() in the CF as the rule...
=countif(range, "word")>0
=countif(range, "word")>0
