Conditional formatting - how to populate through 150.000 rows?

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
 
B

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)
 
M

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
....?
 
M

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
 
P

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
 
C

Craig Schiller

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting 1
Copy Conditional Formatting to Another Sheet 3
Generating a list of Conditional Formatting used in a workbook 3
Conditional Formatting 1
Whole Column Conditional Formatting 2
conditional formatting with color- five rows at a time? 1
Possible to set up conditional formatting that can be overwritten? 1
Conditional Formatting question... 1

Top