Conditional formatting - how to populate through 150.000 rows?

  • Thread starter Thread starter Mac
  • Start date Start date
M

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
 
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)
 
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
....?
 
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
 
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
 
Or just hit control-A to select all.

Pete_UK said:
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
Click to expand...
 
Back
Top