conditional format fill based on another cell contains...

rjmdc

Active Member
Joined
Apr 29, 2020
Messages
392
Office Version
  1. 365
Platform
  1. Windows
conditional format column E fill based on column I contains...
column I has many services i am looking for specific words as part of the contents and if it contains those words fill cell in column E
what would be the formula?
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
48,367
Office Version
  1. 365
Platform
  1. Windows
i am looking for specific words
How many words are you looking for? Less than 5? Could be a thousand?
Is the list of words stored in the same worksheet? In another worksheet? Not stored anywhere?

and if it contains those words
Does it have to contain all the words or would one be sufficient to colour the cell?

Is there any punctuation in the column I data?

What about a small set of dummy data and expected results with XL2BB so that we can be sure we understand the requirement?
 

rjmdc

Active Member
Joined
Apr 29, 2020
Messages
392
Office Version
  1. 365
Platform
  1. Windows
column I has lists etc.
IDGS camp
IDGS school
OTPS transportation
OTPS Health and safety

i tried =(search("OTPS",$I1))
it gives me a fill
i want to know if its accurate
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
48,367
Office Version
  1. 365
Platform
  1. Windows
i tried =(search("OTPS",$I1))
You said in post 1 that you were looking for "specific words". You also said "if it contains those words" This formula is only looking for one word. I am confused. Can you clarify?

What about a small set of dummy data and expected results with XL2BB so that we can be sure we understand the requirement?
 

rjmdc

Active Member
Joined
Apr 29, 2020
Messages
392
Office Version
  1. 365
Platform
  1. Windows
specific word
if contains IDGS hilite blue
if contains OTPPS hilite blue etc
 

Watch MrExcel Video

Forum statistics

Threads
1,126,999
Messages
5,622,115
Members
415,878
Latest member
jjj12345

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
Top