I have data in cells T11:U19. I need to clear contents in the cells in U and adjacent cells in T if a zero is found in U. For example, if U15 contains a zero, I need to clear the contents in cells U15 and T15. I can't delete the cells because I have other data and I don't want the other data to shift. Any help is appreciated.