Hi.

Hope someone can help me;

I have written the following code using the Macro recorder and edite
it a bit and it does half of what i want it to do. It finds any cell i
the range that contains a '0' and then turns it red.

But what i need it to do is if it finds a '0' in the range BU4:BW4 o
below it needs to turn the row that cell is in to red font from BT:CC.

I don't know if the above makes sense. So heres an e.g.

In BU7 there is a '0' so then it turns from BT7 to CC7 into red font.

Here's what i have so far.

For Each sh In Worksheets
sh.Activate
Range("BU4:BW4").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.FormatConditions.Delete
Selection.FormatConditions.Add Type:=xlCellValue
Operator:=xlEqual, _
Formula1:="0"
Selection.FormatConditions(1).Font.ColorIndex = 3
Nex

--
Message posted from http://www.ExcelForum.com