Function to get Cell font color

[Amit_KK]

Hello folks, can we make or there is existing function to get cell font color to referred cell by using or without VBA ??

Please help.

Thanks

 

[herofox]

You can Try by this
Excel formula to get cell color

 

[vletm]

Amit_KK
from below would find cell font color too..

Info only - get.cell arguments

Get.cell (an old xl 4 macro function) can be used to return more info about the worksheet environment than is available with the cell() function. No VBA code (or skills) are required. One complication is that you cannot use get.cell directly in the worksheet. However, there is a...

www.mrexcel.com

 

[Amit_KK]

Thanks a lot!!

 

[Amit_KK]

You can Try by this
Excel formula to get cell color

Thanks a lot!!

 

[AlanSidman]

And if interested, here is a VBA solution.

Sub FindColor()
MsgBox "Background " & Selection.Interior.ColorIndex
MsgBox "Font " & Selection.Font.ColorIndex
End Sub