Conditional formatting doesn't actually change the color index of th
cell so your code won't find any cells that meet your condition o
interior.colorindex = 38.

Check out Chip Pearson's site that covers this problem.

http://www.cpearson.com/excel/CFColors.htm

HT

--
bhofset
-----------------------------------------------------------------------
bhofsetz's Profile: http://www.excelforum.com/member.php...fo&userid=1880
View this thread: http://www.excelforum.com/showthread.php?threadid=38530