| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
Quote:
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. | Excel Worksheet Functions | |||
| Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
| Naming a non-blank range from a col containing non-consec. blank c | Excel Worksheet Functions | |||
| Start Cell B1 then find first blank cell, insert subtotal, next non blank, then next blank, sutotal cells in between......... | Excel Programming | |||
| Sumif to return a blank if sum range is blank | Excel Worksheet Functions | |||
Linear Mode
