Program List If Function

[MrDB4Excel]

I have a worksheet containing cells G3:G100 that needs text and fill formatting via a “Conditional Formatting” rule that looks at the corresponding cell in the “H” column to see if the text contains any one of the letters B, D, F, H, J, L, N, P, or R. The actual contents in H3:H100 are any one of the following B2, D2, F2, H2, J2, L2, N2, P2, or R2. I have tried various if functions and nothing seems to work. It appears I will need to have 9 separate rules, each rule having a specific format for text and fill – or – maybe not; maybe one formula that looks at all 9 possibilities. But this seems not doable as each of the 9 letter indications needs separate formatting.
Thanks for any help.

 

[Special-K99]

Yes, separate formatting requires a rule for each format.
However you should be able to get away with a simple formula for each format, perhaps

ISNUMBER(SEARCH("B",H6))

and format as required.
Just change the letter to search for and the formatting for each rule.

Usual method is to select the entire range in column H you want highlighted, e.g. H6:H1000, then enter the formula above.
The formula will adjust for rows 7:1000

 

[MrDB4Excel]

Thanks Special-K99, It works after I changed the formula to this: =ISNUMBER(SEARCH("B2", H3:H100)) cell H3 being the first with data in it.