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?