mark just cells containing data in a range
 

I have a named range "myCells" (one column)

I know there is a function to mark jsut blank cells in Excel, however
haven't found any function to mark all cells containing some kind o
data.


how can I do this

--
Ctec

-----------------------------------------------------------------------
Ctech's Profile: http://www.excelforum.com/member.php...fo&userid=2774
View this thread: http://www.excelforum.com/showthread.php?threadid=52447

mark just cells containing data in a range
 

Hi Ctech,

You could use Conditional Formatting ...
Cell Value Is equal to =""
and pick a format you want .....

HTH
Cheers
Carim

mark just cells containing data in a range
 

In Conditional Formatting, use

=(NOT(ISBLANK(A1)))

changing A1 to whichever cell begins your range, and apply your desired
format. Then use the Format Painter to copy the formatting to the rest
of the cells in your range "myCells".

mark just cells containing data in a range
 

I seem to have used a couple of extra parentheses. This CF formula
works just as well:

=NOT(ISBLANK(A1))