Conditional Formatting help - Highlighting row containing text

Hi there,
New to the forum,
I have created a spreadsheet which I would like to highlight rows that contain any one of a few words.
I.e in column I there is a drop down list of various names: Gordon, Rob, John, Shaun, DIY & Not Set. I would like the row to be highlighted if column I has any of the names selected.

I have been able to sort of do this with just Gordon but I have not been able to add any other names to the formula. I have also only been able to do it for 1 row. Can someone please lend me some assistance with this please.

Thanks in advance

Capture-excel.PNG
Capturexcel2.PNG

Try CF rule something like

=OR(C1="John",C1="Fred",C1="Bill",C1="Marie")

Thanks for the quick reply!!!


That's worked but it only highlights column I, how do I get it to do the whole row.
So I would ideally like from B19 to I19 highlighted and not just I19
After that how would I duplicate this to all the other rows in the spreadsheet?

Capture3.PNG
Capture4.PNG
Capture5.PNG

How would I post a small sample file?

To Attach a File:

1. Click "Go advanced" and scroll down to "Manage Attachments"
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

Ok, thanks,

So I have attached a copy of it, It is on the Dec worksheet. Column I row 19 is the one with the formula already started, I would like it to highlight the whole row, and for this to be carried over for the whole worksheet. Ie the whole left hand side - under the 3 month visit heading. And I would like it to work for any of the names ie - Gordon, John, Rob, Shaun.


Thanks alot!

Hi there, just looking for an update on this?