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

Hi Ctech,

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

HTH
Cheers
Carim

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".

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

=NOT(ISBLANK(A1))