Enter this macro:

Sub Macro1()
Dim r As Range
For Each r In Selection
If IsEmpty(r.Value) Then
r.Interior.ColorIndex = 6
End If
Next
End Sub

Select any range of cells that you want to examine and mark and run the macro.

Please note that this macro will only color empty cells, not cells that are
blank by reason of formula result.

Have a good day!
--
Gary's Student


"srinivasan" wrote:

I have a worksheet with data and some areas do not have data to be filled in
later. Before checking I want to identify the cells which are blank with a
color so that these can be looked and data fed. i think this can be done by
go to special command. But I want some one to provide me with a code so that
the same can be used for other worksheets also.

thank in advance. I am using excel 2003

seenu