IF function, contains a string
Solved
Skiitle
Posted messages
13
Status
Membre
-
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
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
=IF(COUNTIF($A1,"*Commercial actions*"),"yes","no")
Thank you very much, have a great day