How to set specific value if font is colored

[stillg]

Hello.
I need some help.
I have a test with 850 questions. Each row consists of starting from row 3 /number of the question (A3), the question itself(B3), Answer 1(C3),Answer 2(D3), Answer 3(E3), Answer 4(F3), Correct answer (G3).
The right answer among all 4 available answers is colored in BRG(0.0.255) Blue.
If the right answer is Answer 3/ colored in BRG(0.0.255) Blue/ - to appear 3 in Correct answer column G3.
If the right answer is Answer 4/ colored in BRG(0.0.255) Blue/ - to appear 4 in Correct answer column G3.
So I can apply this condition to all 850 questions.

Thank to all.

 

[stillg]

In that case use the code supplied by Saurabhj but change "Sheet1" to "Table 1"

The script runs without any error, but there is no result in my table.

 

[Fluff]

That would suggest that none of the cells have a blue font of RGB(0,0,255)

 

[stillg]

In that case use the code supplied by Saurabhj but change "Sheet1" to "Table 1"

The code runs without an error , but the is no any change or result in my table.

 

[stillg]

That would suggest that none of the cells have a blue font of RGB(0,0,255)

Yes, You're absolutely right. Now I tried to change the font color to RGB(0.0.255) by hand and the code started to work. Now the question is , how I can get the actual color of the font.

 

[Fluff]

If you select a cell with the blue font & run this

Sub check()
   MsgBox ActiveCell.Font.Color
End Sub

what does it say?

 

[stillg]

If you select a cell with the blue font & run this

Sub check()
   MsgBox ActiveCell.Font.Color
End Sub

what does it say?

I guess everything with the Font color is messed up with the conversion from PDF to Excel.

 

[Fluff]

Ok, that suggests that the text in the cell is only partially coloured, rather than the cell font colour being changed.

 

[stillg]

Ok, that suggests that the text in the cell is only partially coloured, rather than the cell font colour being changed.

All the text in the cell with the correct answer is colored in blue, but I don't know why it can not get the actual color. I tried to get the color by selecting the text, go to Font colors, select More colors and finally select Custom.

 

[Fluff]

Can you upload the file to a share site, such as One Drive or Google Drive? If so mark for sharing & post the link to the thread.

 

[stillg]

Can you upload the file to a share site, such as One Drive or Google Drive? If so mark for sharing & post the link to the thread.

Vyprosi_40BT.xlsx

drive.google.com