https://bugs.documentfoundation.org/show_bug.cgi?id=150712
--- Comment #9 from Pierre Fortin <[email protected]> --- To confirm, this workaround is super fast (to help anyone needing a fast solution) to conditionally format an large|jumbo sheet: - using a previously formatted [sample] sheet: Copy a cell which has desired conditional formatting - On sheet needing format: - locate bottom-right of HUGE range (note cell) - return to top-left of range - select a few top-left cells to be formatted - Edit->Paste->Paste Special... Click Formats Only - Format->Conditional->Manage... - Selected range is highlighted - click Edit... - Range: (at bottom) Change to cover the huge range you need formatted (e;g., B2:SG320976 (yes, that's 160,488,000 cells) - Click OK - Click OK Formatting is applied instantly. A few more steps than the expected manner; but this is FAST w/o 100% CPU. -- You are receiving this mail because: You are the assignee for the bug.
