I need, what I hope is some quick help!!??
I have the code below that does what I want; it Coverts the EFFECT of the Condition Formatting rule to a FIXED interior colour matching the CF effect, it then deletes the rule.
What I want to do is incorporate a pop up Inputbox into the existing code to select the range to covert, rather than have to preselect the range before I run the sub.
I have the code below that does what I want; it Coverts the EFFECT of the Condition Formatting rule to a FIXED interior colour matching the CF effect, it then deletes the rule.
What I want to do is incorporate a pop up Inputbox into the existing code to select the range to covert, rather than have to preselect the range before I run the sub.
VBA Code:
Sub FixColor()
Dim r
For Each r In Selection
r.Interior.Color = r.DisplayFormat.Interior.Color
Next r
Selection.FormatConditions.Delete
End Sub