View original (French)

IF function, contains a string

Solved
Skiitle Posted messages 13 Status Member -  
Skiitle Posted messages 13 Status Member -
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 Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    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 Posted messages 13 Status Member
       
      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