Have a range of rows/columns with various numbers entered. Initiated conditional formatting, but won't format until I re-enter each individual number. Rules are correctly entered, format is set for number. Tried copy/paste format, didn't work. What can I do to keep from re-entering each number?

Thanks!