Uhhh....

Okay, you lost me. I understand the point, but this just returns me a 0 every time.

Here's the deal... Data will be in range("A3:G" & Range("A65536").end(xlup).row)

All I really want to know is if there is 1 cell with a colorindex of 6 (set through the contional format).