Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
odd and even number conditional formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) |