How to identify red color font in Excel

Hi Team

I’m trying to identify red color font excel "E F G column

First Bot Need to check E column if red color font available it should click on red color and send mail, IF not available need to check column F and like wise another coloum

Hi @sachin_hu ,
Please go through this link:

I hope you will get your solution from this.

If not, please feel free to reach out.

Thanks & Regards,
Shubham Dutta

this is for particular cell

but in my excel only font is colored and it my be any were in column

HI @sachin_hu ,
If you want text colour then go through this link:

Thanks & Regards,
Shubham Dutta

i have tried this one but its for particular cell

in my excel it my be in any cell red font

1 Like
  1. put below code in txt file e.g. “vba.txt”
Function CheckRedFont(sheetName As String) As String
    ActiveWorkbook.Sheets(sheetName).Activate
    CheckRedFont = ""
    Dim r As Range
    For Each r In ActiveSheet.UsedRange
        If r.Font.Color = vbRed Then
            CheckRedFont = "Yes"
            Exit For
        Else
            
        End If
    Next r
End Function
  1. use this .xaml file
    check if red font exist.xaml (8.5 KB)

  2. change excel path and sheet name if needed

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.