Conditional formatting

[alsan]

Kindly see the attached excel file I'm working on and a description of what I need is in there ...


Thanks
Hassan

[leelnich]

Hi Alsan. Try this CF formula for cells B3:B10:

Please Login or Register  to view this content.

[leelnich]

...Or perhaps:

Please Login or Register  to view this content.

...if you don't trust the "anything but "P"" approach.

[samba_ravi]

Select the data from B3:B10 and use below formula in conditional format apply formats as per your need

=SEARCH(" "&INDEX($C3:$J3,MATCH($K$1,$C$2:$J$2,0))&" "," O PO PH ")

[leelnich]

Yet another way. This involves defining a named formula, because you can't use array constants in CF. In Name Manager, define Off_Codes. In the Refers to: box, type {"O","PO","PH"}. Now you can use that in this CF formula:

Please Login or Register  to view this content.

[alsan]

Happy and a blessed happy new year 2018 to all! Thanks to leelnich and every one for your solutions!!