Using conditional formatting to highlight an entire row based on one cell

**eizanendoso** · 07-30-2012, 05:03 AM

Hi there!

I'm confused whether to use SEARCH, OR, or IFNUMBER or other similar functions to use as a conditional formatting formula.

I basically want an entire row to be highlighted green, if the cell in Row F has any of a list of words that is placed elsewhere in the worksheet.

For example,

For row 10 to turn green if F10 has any of the following words:

Senior
Manager
Businessman

and for that to work on the other rows in the worksheet.

I've been trying for hours now but I still can't get it to work /: any help would be much appreciated!!

**zbor** · 07-30-2012, 05:11 AM

Use this as criteria:

Formula:

Please Login or Register  to view this content.

**eizanendoso** · 07-31-2012, 02:01 AM

I still can't get it to work using this:

Formula:

Please Login or Register  to view this content.

thanks a lot for the help!

**Fotis1991** · 07-31-2012, 02:23 AM

Hi

Maybe you can use something like this,if your list is not big..

=OR($F$10="senior",$F$10="Manager",$F$10="Businessman")

**zbor** · 07-31-2012, 02:57 AM

You want to see if there is any word of above in F10?

For example in F10:

Please Login or Register  to view this content.

should return TRUE in conditional formatting?

Try this:

Formula:

Please Login or Register  to view this content.

---------- Post added at 08:57 AM ---------- Previous post was at 08:54 AM ----------

For more words you can define list

**eizanendoso** · 07-31-2012, 03:50 AM

Thanks so much for the help guys,

What I did was this:

Formula:

Please Login or Register  to view this content.

where it searches G2 for the words in 'lists' (Name Manager). If it finds any one of the words on the list, its supposed to turn to 'Y'. I then created a conditional formatting rule to highlight the entire row if there is 'Y'.

It works, but only for the first word on the list: senior

***

THANK YOU ZBOR! I just tried out your solution and it worked. thank you very much! been very many hours (:

And thank you very much too Fotis!

**Cutter** · 07-31-2012, 09:59 AM

@ eizanendoso

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.