Re: Conditional Formatting Help

Domenic,

Yeah. I often find it handy to start at the bottom, and drag up. That way,
I don't have to worry about going too much farther than I wanted to, since
it stops when I crash into the top. Lazy people have lots of tricks. Then
I can back down to the top cell of my desired selection before I let go of
Mr. Mouse. In this case, B2 wouldn't be active, though one press of Enter
fixes that.

--
Earl Kiosterud
www.smokeylake.com/
-------------------------------------------

"Domenic" <domenic22@xxxxxxxxxxxx> wrote in message
news:domenic22-AA1E20.13203909072005@xxxxxxxxxxxxxxxxxxxxxxx
> In article <#I1WJUKhFHA.3316@xxxxxxxxxxxxxxxxxxxx>,
> "Earl Kiosterud" <nothanks@xxxxxxxxxx> wrote:
>
>> To add to Domenic's reply, it's important that the active (white) cell of
>> the B2:B100 selection be B2 to use his formula. It probably would be,
>> but
>> it's possible it not be. I thought it's worth a mention.
>
> Thanks Earl! Good point! I assumed that B2 would be selected first,
> but I suppose there may be those who would select B100 first. I'll have
> to keep that in mind for the future. :)


.