I have a conditional format in place to highlight text in columns A – I as information is entered in column L. I would like to now delete or change the information in adjacent cells to be blank or 0. For example, when amag is entered in L1, B2 is highlighted and cells A1 and C1 will be blank or 0. In my sheet Columns A,C,D,F,G and H are all formatted as hh:mm all other cells formatted as text.
Can see previous question about the conditional formula in this link: Excel: Conditional formatting formula based on text list