Highlight Cells Which Contains Desired Multiple Words

[Galav Dani]

Hello Sir.... I want to highlight cells of a single column with a color which contains two text strings of my desire.

threre are a lot of rows in that column..

as an example I want highlight those cells which contains "concrete" and "slab" from my selected column.

please reply.

 

[NARAYANK991]

Hi Dani ,

Should a cell be highlighted only if it contains both the words "Concrete" and "Slab" ?

Or should it be highlighted if either of the two words is present ?

Narayan

 

[Somendra Misra]

Hi Galav,

Welcome to chandoo.org forum.

Care to upload a sample file with column of data and where you will enter your choice of words.

Regards,

 

[Galav Dani]

Hi Dani ,

Should a cell be highlighted only if it contains both the words "Concrete" and "Slab" ?

Or should it be highlighted if either of the two words is present ?

Narayan

 

[Galav Dani]

Thx sir for your swift response...I had uploaded sample file for your ref. I want to highlight all cells which contains below two words only.

1. concrete 2. slab

only those words should be highlighted which contains these two words only.

 

[Galav Dani]

sorry sir....only those cells should be highlighted which contains concrete and slab both words.

 

[Galav Dani]

Hi Dani ,

Should a cell be highlighted only if it contains both the words "Concrete" and "Slab" ?

Or should it be highlighted if either of the two words is present ?

Narayan

Yes sir..both words then only that cell should highlight.

 

[Somendra Misra]

@Galav Dani

In you data none of the row has data with two words, if it is there you can use below formula for CF.

=ISNUMBER(SEARCH("concrete",A3))*ISNUMBER(SEARCH("slab",A3))

in whole column where there is data.

Regards,

 

[Galav Dani]

@Galav Dani

In you data none of the row has data with two words, if it is there you can use below formula for CF.

=ISNUMBER(SEARCH("concrete",A3))*ISNUMBER(SEARCH("slab",A3))

in whole column where there is data.

Regards,

sir..i had done conditional formatting using above formula you suggested and select a color for to highlight. but its not giving desire results.

 

[Somendra Misra]

Select A3:A9847 with active cell as A3, go to CF apply a rule , put formula and select format.
See below pic.


Regards,

 

[Faseeh]

@Galav Dani,

Please try this in conditional formatting:

=IF(OR(IFERROR(SEARCH("Slab",A5)>0,FALSE),IFERROR(SEARCH("Concerete",A5)>0,FALSE)),1,0)

 

[Galav Dani]

sir...its done....really worked...thx a lott for your kind support...

 

[Somendra Misra]

I think its spelling mistake of concerete.

Regards,

 

[anuwers]

I think its spelling mistake of concerete.

Regards,

Can we have VBA CODE to get it highlighted automatically when we enter concrete or slab

 

[Marc L]

Can we have VBA CODE

See in appropriate forum, here is the one for Excel formulas …
​