View original (French)

IF function, contains a string

Solved
Skiitle -  
Hello everyone,

I'm a bit hesitant to post here, but I'm going in circles, so if someone could shed some light on this, I would be grateful :D

So here's the main idea: I want to create a Gantt chart in Excel, so far so good.

I'm simply having difficulty with "conditional formatting."

Basically, my column "A" contains different tasks like Action, Presentation, Other...

And I'd like to conditionally format (in yellow for example) the tasks that start with "Action."

The only problem is, I'm not getting the expected result.

I tried to do a little logical test in an adjacent cell, and again the result is incorrect. (I'm only getting "FALSE")
I can't find my mistake :/

=IF($A49="*Action commerciale *","TRUE","FALSE")

Looking forward to hearing from you,

Best regards,

Rémi

PS: Office 2013 in English

2 answers

  1.  Vaucluse Contributor
    Hello

    French version, use COUNTIF:

    =IF(COUNTIF(A49,"*Action*"),True,False)

    regards

    ps
    for conditional formatting, it's better to avoid the IF
    in the CF formula

    =COUNTIF(A49,"*Action*")

    will suffice

    To err is human, to persist is diabolical
    2
    1. Skiitle Author
      Yes indeed, I just found it on an auxiliary site

      =IF(COUNTIF($A1,"*Commercial actions*"),"yes","no")

      Thank you very much, have a great day
      0