mark just cells containing data in a range

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ctech - 20 Mar 2006 18:28 GMT

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

Reply to this Message

Carim - 20 Mar 2006 18:36 GMT

Hi Ctech,

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

HTH
Cheers
Carim

Reply to this Message

Mark Lincoln - 20 Mar 2006 18:50 GMT

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

Reply to this Message

Mark Lincoln - 20 Mar 2006 19:00 GMT

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

=NOT(ISBLANK(A1))

Reply to this Message