Copying Formatting - 'Selection Too Large'

[RJB]

So I have a file that's 42,000 lines long.

Trying to drop in a conditional format... I format one line the way I want,
hit the copy format button, and try dragging it across the cells...

- - "Selection Too Large".

Copy, Paste Special "Formatting Only"...

- - "Selection Too Large".

Click Copy Format, click on upper left corner...

- - "Selection Too Large".


I'm beginning to think my selection is too large.

Thoughts on formatting all lines?

Thanks

 

[Rick Rothstein \(MVP - VB\)]

Conditional Formatting is not the same as cell formatting... you don't copy
it to other cells... you select all the cells you want to apply it to and
write the condition treating the active cell as if it were the only cell...
the Conditional Formatting dialog will copy it to the other cells for you
(adjusting relative references as required while maintaining all the
absolute references). If you provide more detail as to what your conditional
formatting requirements (formulas) are, I'm sure someone here will show you
how to implement them.

Rick

 

[RJB]

Conditional Formatting is not the same as cell formatting... you don't copy

it to other cells...

And yet, you CAN copy it to other cells, using either the paintbrush icon or
Copy-Paste Special "Formats" (or Ctrl+Shift+C, Ctrl+Shift+V)...

All I'm doing is if $A2=1, underline cells A2:R2. ($A3=1, A3:R3, etc.)