need to create dynamic chart based on color of cells

[divuraj]

Hi,

I have my values in last column which is also dynamically increasing week on week. i have the last column value already and now i need to check whether there any values in red and need to create line graph only for values which are in red for the last 12 weeks.

this is the code which i have used , i have code before this as well. am i going wrong somewhere, this code does not give any msg box which i have written just to check. i have conditional fomratting in the range and cell BH11 and BH14 are in red.

Range(Selection, Selection.End(xlUp)).Select

Range(Selection, Selection.End(xlUp)).Select
Selection.End(xlDown).Select

cel4 = ActiveCell.Row
j = ActiveCell.Column
For i = 2 To cel4

If Cells(i, j).Interior.ColorIndex = 3 Then
msgbox "success"
End If

Next


please help...

Thanks,
divuraj.

 

[Andrew Poulsom]

The ColorIndex property doesn't return the color of a conditionally formatted cell. Look here:

http://www.cpearson.com/excel/CFColors.htm

 

[divuraj]

Thanks, i guessed it. not a problem i will use the cells.value property.

divuraj.