question1
Sub colofif()
mc = 6
For i = 2 To Cells(Rows.Count, mc).End(xlUp).Row
Rows(i).Interior.ColorIndex = 0
If Cells(i, mc) < 0 Then Rows(i).Interior.ColorIndex = 36
Next
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Newbee via OfficeKB.com" <u27679@uwe wrote in message
news:796314d162383@uwe...
Good Day,

I'm still kind of new at writing macro's and had two quick questions. Is
there a way to find in a selected data in Column AI if there is a negative
integer to highlight, well more like fill row with a color. The follow up
question would be could i do the following, with a selection of data could
you do this...If Column AI has #DIV/0! and Column AN has a 0 hide that
row,
but it has to have #DIV/0! (AI) and a 0 (AN). Thank you very much and i
do
apprectiate any help i can get with this.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200710/1