Conditional Formatting Formula To Highlight Flagged Entry

[Strummer]

I have a list of names in column A and I flag some of the names with a “!” in column C.
This is to notify me that this particular name has to be entered in bold type if it comes up at a later date. One problem I have is that the name will probably have a different number before it.
The name may be in the list several times but I only want the name to be in bold AFTER the flag has been put in.

A C
2 Bonza Crop !
9 Camarilla
4 Empire Burlesque
1 Fancyfree !
1 Decerto
1 Regal Celeb
3 Air Raid
14 Here De Angels !
3 Orange County
12 Bonza Crop


Is there a clean and efficient way to write a formula in the conditional formatting facility to get this done?

Thanks
Strummer

[NBVC]

Select the List in Column A,

Go to Format|Conditional Formatting

Select Formula is from the 1st drop down and enter formula =$C1="!"

(assuming the first item you selected is in A1. If not adjust C1 to correspond with top most row selected).

Click Format and choose Bold from the Font tab.

Click Ok, click ok again.

[Strummer]

Hi NBVC,
That format appears to only highlight the name when there is a flag next to it.
I need a formula to highlight the name when it comes up further down the list.

So in A1 "2 Bonza Crop" was flagged with a "!"
Therefore when is shows up again in cell A10 as "12 Bonza Crop" it needs to be highlighted in bold type.

Any suggestions? I think i'd need some sort of Index/Match function with offset so it doesn't look for the same name above the flag.

Thanks
Strummer

[NBVC]

Okay try this then.

Select all of range in column A except for A1.

Go to Format|Conditional Formatting and select Formula Is from 1st drop down, then enter this formula:

=MATCH(TRUE,(MID($A$1:A1,FIND(" ",$A$1:A1)+1,LEN($A$1:A2))&$C$1:C1=MID(A2,FIND(" ",A2)+1,LEN(A2))&"!"),0)

Click Format and choose Bold from the Font tab.

Click ok, click ok again....

Now when you enter an "!" in column C, the matching names in Column A below that item will turn Bold.

Is this what you were after.

[Strummer]

NBVC,
That works perfectly!

Thank you very much for that.

Strummer

[NBVC]

NBVC,
That works perfectly!

Thank you very much for that.

Strummer

Great! You're welcome!