Background: I want to highlight the cell (red) if stated WBS used towards an Application has a WBS Description indicating that the WBS is ‘closed’.

Following formula is working on specific WBS Description:

               =IF({Applications Master Data.Stated Operations WBS Description}="CLOSED - OM Endur O&P","red","")

But If I try to use wildcards to detect WBS Descriptions contain ‘closed’ I feel the taste of failure :-)

Using R11

Case-insensitive:

=If(Search("closed", {Applications Master Data.Stated Operations WBS Description}) > 0, "red", "")

Case-sensitive:

=If(Find("closed", {Applications Master Data.Stated Operations WBS Description}) > 0, "red", "")

Thank you Christopher Davidson

Cut and paste and both formulas you supplied worked.

It seems that using 'Search' isn't case-sensitive which is what I need. It was case-sensitive using 'Find'.

Should be the other way around - at least that's what a recent test showed when we were using the FIND logic - SEARCH is case sensitive and FIND is not - now I think I'll go back and test again before we push our fix to production - eek!

Confirmed - FIND is not case sensitive - whew!