loop not working

[daveyc18]

For i = 9 To finalrow
If Range("k" & i).Interior.Color <> 16777215Then
Range("q" & i).clear
End If

so i have conditional formatting in column K to highlight (yellow) and when i do ?activecell.interior.color in the immediate window for the highllighted, it returns 16777215., which I believe is NOT yellow (clicking another cell thats not highlighted returns the same value)

so, i tried <> vbyellow, but loop still doesnt work (ie cell in column Q does not get cleared if cell in column K is NOt yellow highlight)

 

[Akuini]

Instead of Interior.Color, try DisplayFormat.Interior.Color
Ref:
Range.DisplayFormat property (Excel)

 

[Michael M]

I believe your color 16777215 is actually white

White color (Decimal 16777215)

Decimal 16777215 color converted to 17 different formats like RGB, CMYK, HSV, HSL.The Decimal color 16777215 is a light color, and the websafe version is hex FFFFFF, and the color name is white. A complement of this color would be 16777215, and the grayscale version is 16777215.A 20% lighter...

convertingcolors.com

Why not change column K to

For i = 9 To finalrow
If Range("k" & i).Interior.Color <> vbYellow Then
Range("q" & i).Clear
End If
Next i

 

[daveyc18]

ye...I tried ...doesn't seem to work

it's weird how it returns white on the conditionally formatted cell

 

[Akuini]

ye...I tried ...doesn't seem to work

What did you try?
I set conditional formatting with red light color

?ActiveCell.Interior.Color
 16777215
?ActiveCell.DisplayFormat.Interior.Color
 13551615

 

[Fluff]

it's weird how it returns white on the conditionally formatted cell

That's because the interior colour of the cell is white, it's just the displayed format (ie the CF) that is yellow, which is why you need to use DisplayFormat as shown by Akuini.

 

[daveyc18]

What did you try?
I set conditional formatting with red light color

?ActiveCell.Interior.Color
16777215
?ActiveCell.DisplayFormat.Interior.Color
13551615

sorry, my earlier reply was to another answer

your solution worked....just had to change to color 65535...thanks!

 

[Akuini]

You're welcome, glad to help & thanks for the feedback.