What is the cell colour?

[lotsbg]

Any way to work out what a particular cell colour is?
I have this file that has background cell colours, and basically I want to delete all the rows which have a particular colour.....I don't know what the colour is, so I can't do an if statement....

anyone with any ideas? much appreciated

 

[Norie]

How are these cells being coloured?

 

[lotsbg]

Not sure. They are a file from another source with the cell already coloured.

 

[lotsbg]

managed to work it out using the following:

For Count = 1 To 100
If ActiveCell.Interior.ColorIndex = Count Then Exit For
Next Count

Thanks for your help