Conditional Formula - What If

Closed
lsteedly Posts 1 Registration date Tuesday April 7, 2015 Status Member Last seen April 7, 2015 - Apr 7, 2015 at 02:24 PM
MaxStart Posts 340 Registration date Tuesday March 3, 2015 Status Moderator Last seen July 3, 2015 - Apr 7, 2015 at 03:48 PM
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

MaxStart Posts 340 Registration date Tuesday March 3, 2015 Status Moderator Last seen July 3, 2015 69
Apr 7, 2015 at 03:48 PM
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