What conditional formula can I use that will take use cell D3 (number in the orange frame box), then highlight the row base on the value?
Example Below: #16144 should highlight row 17?
Example: If the # is 42,000 then highlight row 2, but if its right under 45000 then highlight 3