Conditional Formatting with a text string

Hawkman

New Member
Joined
Jan 10, 2008
Messages
12
I am trying to use the conditional formatting feature (of Excel2002) to highlight cells which contain a text string (in this case a last name) from a drop down list I created.
For example, if I select the name "Monroe" from the drop down list, all the cells in my conditional formatting range that contain only "Monroe" in the cell turn green as I want. (I used the cell-- is equal to command in the conditional formatting box). But when the cell contains more than just "Monroe" such as "Monroe/Smith", the cells do not get highlighted. How do I get the conditional formatting to apply to every cell that contains "Monroe" regardless if there is more in the cell or not?

Thanks for any help with this matter.
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
Try
=IsNumber(Find(CellHas"Monroe",CellYouwantToHighlight))

Use Search function in stead of Find, when you need it non-case sensitive
 
Upvote 0

Forum statistics

Threads
1,214,920
Messages
6,122,276
Members
449,075
Latest member
staticfluids

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top