ColorIndex ...

[jlarkin]

"if range("c8")="Dan" and range("c8").interior.colorindex=6 then"

Ahhh...

I had this same exact line except without the "interior" befor
colorindex... I think I can get it going now..

 

[Don Guillett]

glad to help. Looked like you were missing some ..... also