A

#### Albert Mulder

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

After that I have a row with 7 Cells. I need these cells to sort lowest to

highest.

As far as I can tell it would be the formula be.

Example:

C1=0 (A7) Formula =SMALL(D410, 1)

C2=4 (A3) Formula =SMALL(D410, 2)

C3=5 (A2) Formula =SMALL(D410, 3)

C4=5 (A5) Formula =SMALL(D410, 4)

C5=6 (A1) Formula =SMALL(D410, 5)

C6=8 (A5) Formula =SMALL(D410, 6)

C7=9 (A6) Formula =SMALL(D410, 7)

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.

As far as I can tell part of the formula would be

Example:

E1=X Red Text Formula = SUM(C1) Not sure how to change to and X or Red Text

E2=4 Formula = SUM(C2-C1) Not sure how to change to black Text

E3=1 Formula = SUM(C3-C2) Not sure how to change to black Text

E4=X Red Text Formula = SUM(C4-C3) Not sure how to change to and X or Red Text

E5=1 Formula = SUM(C5-C4) Not sure how to change to black Text

E6=2 Formula = SUM(C6-C5) Not sure how to change to black Text

E7=1 Formula = SUM(C7-C6) Not sure how to change to black Text

Now after that I need

If any answer = 1 then change that Cell to red along with the original

number that corresponds with it. Else change cell to green.

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