asked on pasting font colour from conditional formatting to permanent in excel
Hi experts using excel 2010
I want to paste the conditional formatting colours from the CF rules to permanent colour in excel..how could I do this using vba or another method..
Data range is q11:AA200
I want to paste the conditional formatting colours from the CF rules to permanent colour in excel..how could I do this using vba or another method..
Data range is q11:AA200
Microsoft Excel
Last Comment
route217
easy way is to Copy/paste to Word and back to Excel appears to convert any kind (font, border, pattern) of conditional format to regular explicit format.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
opps, repost:
Sub test()
Dim r As Range, c As Range
Set r = Range("A1:A10")
For Each c In r
c.Interior.Color = c.DisplayFormat.Interior.Color
Next
r.FormatConditions.Delete
End Sub
the solution i uploaded, takes care of all formatting from conditional formatting not just the color. i.e Font Style, Underline and Strikethrough Font Color etc.
ASKER
Thanks for the excellent feedback...all experts..
Both methods work fine
Both methods work fine