YasserKhalil
08-06-2010, 01:56 PM
Hi everybody
I have applied a conditional formatting on the range.
I'd like to refer to the first cell of this range depending on the fill colour that I applied in conditional formatting
This is the code that I used and succeeded in the normal colouring but with the conditional formatting it fails
X = 0
Do
X = X + 1
Set Rng2 = Cells(4, X)
Loop Until Rng2.Interior.ColorIndex = 7
I have applied a conditional formatting on the range.
I'd like to refer to the first cell of this range depending on the fill colour that I applied in conditional formatting
This is the code that I used and succeeded in the normal colouring but with the conditional formatting it fails
X = 0
Do
X = X + 1
Set Rng2 = Cells(4, X)
Loop Until Rng2.Interior.ColorIndex = 7