Highlighting all the blank fields

[dankar]

Hi All,

I have a table with columns from A = O
I want to highlight in yellow all the fields that have blank cells from column G to M.


what is the best way to do it? thank you

 

[Fluff]

Select cols G:M > Home tab > Conditional format > new rule > =G1="" > select the format > ok

 

[dankar]

Thanks for your reply..

it didn't work with me.

FYI,I tried to find & select>Go to special> Blank and the result was: no cells were found although there a lot of blank cells.

 

[Fluff]

That suggests that your cells aren't actually blank.
Do you have formulae in those cells returning "" ?
If not in an unused cell try =len(A1) where A1 is one of your "Blank" cells

 

[dankar]

no Formula in the cells.
when I tried len(G1) TO len(M1) and going down. all the results is 0

 

[Fluff]

Try running this & then see what happens

Sub DelNullString()
   Range("G:M").Value = Range("G:M").Value
End Sub