Can I get rid of conditional formatting but keep format changes?

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?

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?

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?
>

For an introduction to macros see:

http://www.mvps.org/dmcritchie/excel/getstarted.htm
http://web.archive.org/web/200312040...01/default.asp

Regards
Rowan

Spaticus wrote:
> 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?
>>

Hi
If your'e not into macros, maybe this will help:
Go to one cell and change that with conditional formatting just the way you
want it. Click the cell again - then the "formatting-paint-brush-icon" and
then highlight the rows or columns that you want to change, with the
paint-brush and...there you go.
Hope it'll help.
--
Therese


"Rowan Drummond" skrev:

> For an introduction to macros see:
>
> http://www.mvps.org/dmcritchie/excel/getstarted.htm
> http://web.archive.org/web/200312040...01/default.asp
>
> Regards
> Rowan
>
> Spaticus wrote:
> > 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?
> >>
>

thank you both!

"Therese" wrote:

> Hi
> If your'e not into macros, maybe this will help:
> Go to one cell and change that with conditional formatting just the way you
> want it. Click the cell again - then the "formatting-paint-brush-icon" and
> then highlight the rows or columns that you want to change, with the
> paint-brush and...there you go.
> Hope it'll help.
> --
> Therese
>
>
> "Rowan Drummond" skrev:
>
> > For an introduction to macros see:
> >
> > http://www.mvps.org/dmcritchie/excel/getstarted.htm
> > http://web.archive.org/web/200312040...01/default.asp
> >
> > Regards
> > Rowan
> >
> > Spaticus wrote:
> > > 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?
> > >>
> >