Conditional Formula - What If

Closed
Report
Posts
1
Registration date
Tuesday April 7, 2015
Status
Member
Last seen
April 7, 2015
-
Posts
341
Registration date
Tuesday March 3, 2015
Status
Moderator
Last seen
July 3, 2015
-
I need to create a what if statement for a workbook.

Example below... here's what I need, if Column B has the words "Left Blank" I need for it to be highlighted RED only if column A says YES.

Column A Column B
Complete App Status
No Left Blank
Yes Signed
Yes Signed
Yes Left Blank
Yes Left Blank
Yes Signed
Yes Signed
No Left Blank
Yes Signed
No Left Blank
Yes Signed
Yes Signed
No Left Blank

Any thoughts?

1 reply

Posts
341
Registration date
Tuesday March 3, 2015
Status
Moderator
Last seen
July 3, 2015
69
Sub check()

Dim i As Integer
i = 1

    Do While Cells(i, 1).Value <> ""
      If Cells(i, 1) = "yes" And Cells(i, 2) = "Left Blank" Then
          Cells(i, 2).Interior.Color = 255
      End If
    
    i = i + 1
    Loop

End Sub


dreaming is just a waste of time.
0