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

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

Answer 1 / 1

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

Similar discussions

Highlight cell if another cell contains specific text

How to use conditional format based on text?

What shall i do after formatting my laptop?

Excel format

Conditional Formatting: 3 range of numbers

Similar discussions

Subscribe To Our Newsletter!