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
67
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!