Hello! I am trying to create a scoring sheet for a price is right style of game. I want to be able to enter each person's guess in cells B2 through B19 and have it highlight the cell(s) that is/are closest without going over the actual price, which is found in cell B20. I know I need to create a new rule under conditional formatting, but I cannot figure out the formula. I've referenced a few other threads that address highlighting the closest cell, but I'm having trouble limiting it to be less than the reference cell. Any help is appreciated. Thank you!