Check value available or not in 3 cell

[Nitesh Khot]

Hi,

How to compare 3 cells value available or not..

ie. A2 B2 C2

I want to check any if value is available or not in any one of the cell...if 3 cells are empty then highlight as red.

Thanks,
Nikh

 

[PCosta87]

Hi,

In my opinion you don't need VBA for this... just select the cells and apply conditional formatting to highlight if cell =0

If you must use VBA then:

Sub test()

    Dim c As Range
   
    For Each c In Range("A2:C2").Cells
        If c.Value = 0 Then
            c.Interior.ColorIndex = 3
        End If
    Next c

End Sub

Hope it helps

Regards

 

[PCosta87]

I just realized you probably want to highlight all 3 cells if all 3 are blank... if so:
With conditional formatting, use formula like:

=and($A$2="";$B$2="";$C$2="") and format to red background

for VBA:

Sub test()

    If WorksheetFunction.CountA(Range("A2:C2")) = 0 Then
        Range("A2:C2").Interior.ColorIndex = 3
    End If

End Sub

Regards

 

[Khalid NGO]

if 3 cells are empty then highlight as red.

Hi,

You can also try this for CF:

=(A2&B2&C2)=""

Regards,