Conditional Formatting based on partial/specific text to highlight entire row

Assuming your range starts in row 1, highlight the range of cells you want affected by the conditional formatting, then use this as the formula:

=SEARCH("*mort*",$L1)

- Moo

If it starts in row 2, then change $L1 to $L2, etc...

CF has an additional option of "use formula". you can use that for what you want to do.

before you do tho, test the formula in the sheet itself to make sure it gives you TRUE where you need it (CF works on either TRUE or FALSE)

using this option, you can incluse just about any regular excel formula, as long as it's constructed to return TRUE or FALSE

to highlight the entire row, 1st select the entire range you want to apply CF to, then when you reference the "criteria" cell, use absolute (something like $A1)

If you still have a problem, i would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, what your expected outcome is, and how you arrived at that

To Attach a File:

1. Click on Go Advanced
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.

You are welcome, welcome, welcome! Glad I could help.

- Moo

ipolack, welcome to the forum

1st, Conditional Formatting cannot be used to affect only part of a cell - it either changes all, or nothing.

2nd, Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

Carbone, thank you for the feedback

You're quite welcome, Carbone. Glad it helped.

- Moo