The active cell when you select a range of cells is the cell that comes up
in the name box above the header of column A. For instance if you click in
D7 and hold down the mouse button and select D7:D20 then D7 is the active
cell and you obviously have to replace any reference to A1 in the formulas
that were given to you with D7


--

Regards,

Peo Sjoblom

"mailrail" wrote in message
...
I'm highlighting a whole range of cells and trying to get that conditional
format into each one with the same basic formula. Will that work or do I
have
to write an individual formula for each of those 100 or so cells?

"Dave Peterson" wrote:

What was the address of the activecell?
What was the formula you pasted?
What was in that cell?

mailrail wrote:

i highlighted ALL cells to conditionally format.

"mailrail" wrote:

I was curious whether or not I could conditionally format a cell if
it
contains part of what I'm wanting it to look for. In other words, my
cells
contain either "W 14" or DDD 12", for example. I just need the cells
to
change color based on whether or not it contains the "W" or the "DDD"
and not
the number that follows. How do I do this?

--

Dave Peterson