Previous Topic Next Topic

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 339 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 response

Answer 1 / 1
MaxStart Posts 339 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

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses