Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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". |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mark cells that have the same cell data | Excel Discussion (Misc queries) | |||
Can Excel mark or identify duplicate cells in a range? | Excel Discussion (Misc queries) | |||
Can Excel mark or identify duplicate cells in a range? | Excel Discussion (Misc queries) | |||
Can Excel mark or identify duplicate cells in a range? | Excel Discussion (Misc queries) | |||
Mark a range from activecell | Excel Programming |