IF function, contains a string

Solved
Skiitle Posted messages 13 Status Membre -  
Skiitle Posted messages 13 Status Membre -
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 réponses

Vaucluse Posted messages 27336 Registration date   Status Contributeur 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
Skiitle Posted messages 13 Status Membre
 
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