if there is a blank ,how to get the blank cell in a range be highlighted
 

From C2:H30 I have marks of students.If there is a blank cell ,how to find out the blank cell without the entry of marks?I want to get a blank cell(without input) to be highlighted red in a range of cells. thanks

if there is a blank ,how to get the blank cell in a range be highlighted
 

From C2:H30 I have marks of students.If there is a blank cell ,how
to find out the blank cell without the entry of marks?I want to get a
blank cell(without input) to be highlighted red in a range of cells.
thanks

With range selected, use Conditional Formatting Formula "=LEN(A1=0)",
then set the formatting. This assumes A1 is the active cell of your
selected range. If not A1 then substitute in formula for the active
cell of your selected range.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

if there is a blank ,how to get the blank cell in a range be highlighted
 

Oops! ..misplaced closing bracket. Formula should be...

=LEN(A1)=0

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

thanks Garry. you are always there to help. but in this case it is not working. i selected a range C16:F19 and have given the formula like this =LEN(C16:F19)=0 gives me value error message