I know i can do it with conditional formatting but i need more thanthree thats why i posted in here Under ExcelVBA.Sorry should have been more specific.