georgieboy, thanks for that i did see that huge function on the net, Chip Pearsons site i believe, however as i stated i do not need to test for every condition as i know my condition, i also do not need to check to see if the CF is FormulaIs or CellIs as i know that too!

rb, cheers, i didnt try that combination of losing .Item but adding (1) before .Interior, i'll try it a little later when i have access to the workbook i was working on, i hope i don't have to set MyCell as a specific cell as of course i am using MyCell in a loop through a range.

Thanks