I have created a drop down menu in say A1, when one of the selections is selected i have a conditional format set up to change the background colours of cells B2-G2. Is it possible to clear the text from these cells too?