I am working on a database where I would like certain cells (K7) to highlight based on data in another cell (I7). I only want cell K7 to highlight if the number is cell I7 is between 1-50 and if I7 is blank for nothing to happen. Can someone help?