Can I get rid of conditional formatting but keep format change
Thank you for the information. I'm going to try and find out what a macro is
now!
"Rowan Drummond" wrote:
You might be able to do it with a macro e.g.
Sub CdF()
Dim cell As Range
For Each cell In Range("B1:D10")
If cell.Value = Range("A1").Value Then
cell.Interior.ColorIndex = 36
End If
cell.FormatConditions.Delete
Next cell
End Sub
This checks the value of each cell in the range B1:D10 and compares it
to the value of cell A1.
Hope this helps
Rowan
Spaticus wrote:
In excel 2003 i have set up conditional formatting to change a range of cells
fill color if it is equal to text in origonal cell. I want to get rid of the
conditional format but keep the new fill color with out going through the
cells one at a time and changing it manually. Is this possible?
|