View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.programming,comp.apps.spreadsheets
Ken Wright Ken Wright is offline
external usenet poster
 
Posts: 634
Default Locking cell color pattern when sorting rows?

LOL - Well I'll be........

As for the CF - Just tried it in a single cell, and then copied that cells formats to every cell
on the sheet. No probs and only a 37K file. Would that count as applying to cells singly, as
opposed to selecting the range and then applying the CF one time?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------



"David McRitchie" wrote in message
...
Not even Tom Ogilvy can read minds.
http://google.com/groups?selm=OA%24o...%40cppssbbsa03

BTW, I don't recall memory problems with Conditional Formatting,
almost sounds like applying C.F. to cells individually rather than in big
selections.


"Ken Wright" wrote ...
Dave, what are you saying - You mean you're *not* a mindreader????????????? <g