If "A" Column is Bold Text, then "D" Column should return specific text value

Dear Forum,

I am searching the formula for the following situation:

1. I have a master sheet which has A : D column
2. "A" column has a list of individual's name.
3. "B" and "C" column respectively their Age and Gender
4. "D" column is their status of visit to counseling center (Options are "1st Time" or "Follow-Up")

My requirement is:

1. Conditional formatting was done in "A" Column to highlight 2nd time visit names with bold and background color.
2. Now i wanted to have "D" Column should be automatically choose either "1st Time" or "Follow-up". (I have tried ISTEXT, SEARCH, GET.CELL options, but no results) based on "A" Column.

If "A" column has bold text with color filled, then "D" column should return as "Follow-up" (text value)
If "A" column has general text without bold and color filled, then "D" column should return as "1st time visit" (text value)

Kindly guide me.

Regards

Dear Mr. Glenn,

Nice to see you again here, I have used =COUNTIF($C$4:C4,C4)>1 this one. I have attached worksheet for your kind reference.

For your reference:

1. i have done a "define name" for getting bold cell and the name is "bold cell".
2. The "G" Column should be only automatically getting "New" or "Repeat Visit" (Text value).
3. Just i have tried one formula in "K" column. But no proper result.

Thanks in advance

Dear Glenn,

Thanks for your time. Now I have found other option for this requirement. Can you guide me.. is it ok?

Process are as follows:

1. I have set up one helper column (in K column)with this formula "=COUNTIF($C$4:C4,C4)" to find out exact number of times visit by the individual.

2. Based on the helper column, i have applied If condition (in G Column)"=IF(K4=0,"",IF(K4=1,"NEW",IF(K4=2,"REPEAT",IF(K4>=3,"MREPEAT","-"))))" to return my requirement as "New", "Repeat".

Finally i got the result. Is is ok? orelse is there anyother direct method is there?

Regards