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?

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

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?

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?

Can I get rid of conditional formatting but keep format change
 

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?

Can I get rid of conditional formatting but keep format change
 

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?

Can I get rid of conditional formatting but keep format change
 

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?