Thank you for all who have help so far. I have two things left.


(Issue Number 1: Need Cell to only take a one diget number 0-9
)
I have a row with 7 Cells each cell will contain a number. The user will
enter a number into each one, but I only want the user to be able to enter a
number 0-9

Example:
A1=6
A2=5
A3=4
A4=5
A5=8
A6=9
A7=0

(This I have working)
After that I have a row with 7 Cells. I need these cells to sort lowest to
highest.

Example:
C1=0 (A7) Formula =SMALL(D4:D10, 1)
C2=4 (A3) Formula =SMALL(D4:D10, 2)
C3=5 (A2) Formula =SMALL(D4:D10, 3)
C4=5 (A5) Formula =SMALL(D4:D10, 4)
C5=6 (A1) Formula =SMALL(D4:D10, 5)
C6=8 (A5) Formula =SMALL(D4:D10, 6)
C7=9 (A6) Formula =SMALL(D4:D10, 7)

(Got this working also)
After that I have a row with 7 cells. I need these cells to take the lowest
number and enter it into E1, then take the next highest number and subtract
the last lowest number and enter it into the next cell. But if the answer = 0
then enter an X there instead and in red text else change to black text.

Example:
E1=0 So it changes to X
E2=4
E3=1
E4=0 So it changes to X
E5=1
E6=2
E7=1

(Got only part of this working, I can change the cell that returnes (1) but
cant figure out how to have it auto check back to the first cell that caused
it. (The A Cells) I need to be able to tell the user that they need to change
the number they have entered else the formula the have will not work.)

Now after that I need
If any answer = 1 then change that Cell to red along with the original
number that corresponds with it from Cell A1-A7. <-- This last part.
Example:
Cell E3 and A2 would be red cells
Cell E5 and A1 would be red cells
Cell E7 and A6 would be red cells


(Would I need to redo my whole formula? If need be I can just have Cells
A1-A7 & E1-E7) I know it can be done but just don't know how.

PLEASE HELP......