VBA to conditionally format a range

[asad]

Hi All again,

I have the following code which I thought will do the job for me. Unfortunately not.

Sub Int_Col()

With Range("D15:Q101")
If Range(cell.Row, "A") = "" And Range(cell.Row, "C") = "" Then
Range("D15:Q101").Interior.Color = 192
Else: Range("D15:Q101").Interior.Color = xlNone
End If
End With


End Sub

All I am trying to achieve is to highlight only rows that have cells in columns A and C blank (there may be formulas in those that result in blank).

Any help is much appreciated.
Thanks
Asad

 

[Scott Huish]

I guess if it works for you. If you want to provide a dropbox (or something like it) link to your file, I can look at it further.