¡^ Text colored by conditional formatting or cell formatting (such as red negative numbers) will not 0 work.


Use what you learn in this function to modify the previous function,"Retrieve Interior Cell Color Name or Index,"to return the color name.

Textcolor(Rng) The argument is

Rng—The cell to check for text color.

Function example:

Function TextColor(Rng As Range) As Long

TextColor = Rng.Range("A1").Font.ColorIndex End Function

0 0

Post a comment