Link to home
Start Free TrialLog in
Avatar of morinia
moriniaFlag for United States of America

asked on

Adding a sequence number to a row

I would like a formula to compute the sequence number is  red (Column A) on attached spreadsheet when columns "D" and "F" are equal.
Count-IDS.xlsx
Avatar of Anuradha Goli
Anuradha Goli
Flag of Ireland image

If Cells(i, "D") = Cells(i, "G") Then
  Cells(i, "A").Select
    With Selection.Font
        .Color = -16776961
        .TintAndShade = 0
    End With
 ' Else
  
 ' With Selection.Font
 '       .ThemeColor = xlThemeColorLight2
 '       .TintAndShade = 0.799981688894314
 '   End With
  End If

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of redmondb
redmondb
Flag of Afghanistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks, morinia.