I currently used some clunky code that was written some years ago and I know there is a more streamlined way to do it....... i have a worksheet where is number greater than 1 is placed in a cell in a range, lets say, b2:b25 ,which causes the activecell (b2) and seven cells to the right to unhighlight. I need simpler code that will do this, as well as highlight the seven cells to the right if the number in B2 is deleted (blank cell)