Brian, Click into B1 and pull up your conditional formatting menu. Under condition 1, pick "cell value is" then "less than" then click into the last box and type "=A1" (no quotation marks, spaces or $ signs). This will give you a relative reference (as opp... Login to read more.