Hi Bob,

It worked in the test book where conditional formatting wasnt in place
if you read my last post i explain how i have formatted the range
firstly i wanted the workbook idiot proof (i place myself in tha
catagory!) so i used conditional formating so people could tell
variety of things by the three colours, but these were to be th
colours of the text (spots as they will be because wingdings capital
is a spot) but it seeems that you cannot have a case arguement workin
for colours if you have conditional formatting running as they seem t
cancel each other out, i need the number in put to colour the whol
cell and the letter to input into the cell so that conditiona
formatting would take over and colour the text....however they don
work together, i have tried using a statement on the worksheet chang
module like Selection.FormatConditions = False and then true after bu
it doeant support the method or property.

I'm at work and sinkin fast!......the above line i tried the macro run
til it has runtime error if i end debug the built in CF takes over an
i can now get spots but the code u gave is disabled!

Looking forward to your reply!

Simon

--
Message posted from http://www.ExcelForum.com