How to identify red color font in Excel

Help Studio
, ,
1

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

image
image1366×768 115 KB

2

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

3

this is for particular cell

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

4

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

Thanks & Regards,
Shubham Dutta

5

i have tried this one but its for particular cell

in my excel it my be in any cell red font

1 Like
6
  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

    image
    image1102×440 18 KB

1 Like
7

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