Brain not functioning..how to i get a cell to conditional format a colur if it contains a certain letter

[damian_r_Home]

Morning.
Yes i shoul dknow this one, but i don't...

In cell T24 i want it to change colour using conditional formatting if cell I24 contains the letter C ... the problem is that cell I24 may contain any of the text C1, C2, C3, C4, etc etc

What is the formula please?

 

[earthworm]

Example will be helpful to give solution

 

[Rick Rothstein]

Give this Conditional Formatting formula a try...

=COUNTIF(T24,"*C*")

 

[earthworm]

Give this Conditional Formatting formula a try...

=COUNTIF(T24,"*C*")

Does this formula means that any letter beings or end with C
what is the function of * please explain as i have seen many tutorials on internet but its confusing .

 

[bebo021999]

@earthworm

For "xxxCxxx"
=COUNTIF(T24,"*C*")

For "Cxxx"
=COUNTIF(T24,"C*")

For "xxxC"
=COUNTIF(T24,"*C")

 

[earthworm]

@earthworm

For "xxxCxxx"
=COUNTIF(T24,"*C*") (Any character before and After C )

For "Cxxx"
=COUNTIF(T24,"C*") ( C must be at starting only after any character)

For "xxxC"
=COUNTIF(T24,"*C") (C must be at the end only before any character)

Is my above understanding correct ?

 

[Rick Rothstein]

I think your understanding is correct, but I believe you need to switch the words "after" and "before" to make the English correct for that understanding.

 

[damian_r_Home]

Morning All

Thank you so much for your help on this.

D

 

[RoryA]

You could also use:

=SEARCH("C",T24)

for a non case-sensitive search, or:

=FIND("C",T24)

for a case-sensitive one.