I have set up a bunch of complicated conditional formatting rules. Now I have added more sheets to the document but the rules only apply to one of them. There is no way to copy&paste them either from what I can tell.
Any ideas?
2 Likes
The results may vary if do you set Value or Min or Percentileā¦
E.g.: The conditional format Color Scale canāt be copied directly if set with Minimum Min and Maximum Max, neither with the Clone Formatting tool (aka paintbrush) nor with Ctrl+Shift+V-Format. But you could paste it in a cell, then choose Manageā¦ and edit the range to cover all cells.
Data Bar doesnāt have this problem.
Working with LibreOffice 6.3.6.2 (x86); OS: Windows 6.1.
I can copy the CF properties to an another sheet (by the format paintbrush) and it works for me. I am tried it with a simple condition:
Cell value = 1
Maybe your conditions are more complicated. Please upload your ODF type sample file here.
My conditions are for a large range (basically for the entire sheet). And I edit them using Format ā Conditional ā Manage.
What do you mean by sample odf?
I meant an Open Document Format sample file, what contains your CF ranges and conditions.
easiest: [select entire sheet - ctrl-c - goto other sheet - cell A1 - shift-ctrl-v - select only āformatsā],
other: [copy formatted cell - paste in new sheet] edit range to apply to in bottom line of [format - conditional - manage - edit], care where you need #relativeā or āabsoluteā ($-ed) addressing ā¦
reg.
b.
P.S. āsolved marksā and ālikesā welcome,
click the grey circled hook - ā - top left to the answer to turn it green if the problem is solved,
click the ā^ā above it if you ālikeā the answer,
āvā if you donāt,
do not! use āanswerā to add info to your question, either edit the question or add a comment,
āanswerā only if you found a solution yourself ā¦
1 Like
I only tried the first suggestion. Seems to work!