Conditional formatting - how to populate through 150.000 rows?

[Mac]

Hello,

the title says it all; say I'm using conditional formatting formula in the
R1 and I want to populate it throughout 150.000 rows (Excel 2007, of course);
is there an easy way to do this (I mean, something instead of having to drag
'the corner' all the way down ...) ? Some kind of a shortcut?
Mac

 

[Bob Phillips]

Select all 15000 and then set the CF based on the first selected cell.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Mac]

Well, that's what I want to avoid.. In other words - now, when the maxrow
limit is much 'far away', are there any ways to 'jump forward', to speed up
....?

 

[MartinW]

Hi Mac,

I don't know if the name box is in 2007, but
in previous versions you simply click in the name
box and enter say A1:A65000 then hit enter.
That will select cells A1 through A65000.

The name box is just to the left of the formula bar
and usually displays the active cell.

HTH
Martin

 

[Pete_UK]

If the data is contiguous in that column, hold down the <shift> key,
press <end> followed by <down-arrow>, then release <shift>.

If not contiguous, then press F5 (GoTo) and enter A150000. Select the
cell in the appropriate column, hold down <shift>, press <ctrl-end>,
select the appropriate cell, then release <shift>.

A third alternative is just to select the complete column by clicking
on the column identifier.

Hope this helps.

Pete

 

[Mac]

Yep, I realized it a few moments ago. Thanks anyway!

 

[Craig Schiller]

Or just hit control-A to select all.

If the data is contiguous in that column, hold down the <shift> key,
press <end> followed by <down-arrow>, then release <shift>.

If not contiguous, then press F5 (GoTo) and enter A150000. Select the
cell in the appropriate column, hold down <shift>, press <ctrl-end>,
select the appropriate cell, then release <shift>.

A third alternative is just to select the complete column by clicking
on the column identifier.

Hope this helps.

Pete