Paste conditional formating as static formating
In the same way you can paste values of a sheet with a lots of formulas I would love to paste formating achieved with conditional formatting. On big spreadsheets, conditional formatting can render the workbook unusable, but it's actually quite convenient to define formatting with conditional formatting. I normally paste formating from a hidden row to set anything I need, but I would love a way to leave the sheet to be fast. Am I explaining myself clearly? Having a conditional format set a cell to red, after "pasting conditional formats to static formats" the actual color of the cell would be red, with no conditional formatting anymore.
I agree this should be one of the "paste special" options.
Currently, I generally need to paste the conditionnal formating itself when I do paste CF (carefully! only 1 cell as a shortcut for duplicating a rule)
But a times I could have used such an option, it might not be something I'd use day to day but it would save a lot of time when I do need it!
In "paste special" there should be an option to convert conditional formatting into static formatting..
I have a spreadsheet that I live in daily with a LOT of conditional formatting. By the end of the year it starts messing up and I'm not completely trusting the data I track. What else can be done besides conditional formatting to prevent this?
Peter McAnena commented
I've often wished for this feature. Conditional formatting is a bit flaky anyway (for example it behaves unpredictably when you insert rows or columns) so I prefer not to rely on it too much.
I also need this fuctionality. I use conditional formating and then I need to paste this result as static formatting before I send it to external correspondants - just like I paste the results of formulas and not the formulas themselves. It allows me to delete the rows necessary to dertimine the value of the cells I will send without changing the values of the cells I need to send. I need the same Thing with conditional formatting!
This is so needed in Excel. I don't know why it hasn't been done yet.