Keeping it larger!!!

[exsam21]

How do I keep the number in the right adjacent cell larger than the previous cell? The numbers are in military time. For example,

a1 b1 c1 d1
0800 1200 1300 1800


How can I make sure that a1<b1<c1<d1?

[Ron Coderre]

1)Select Cells B1:D1
2)Data>Validation
Allow: Custom
(corrected) Formula: =AND(COUNT($A1:A1)=COLUMNS($A1:A1),B1>MAX($A1:A1))
Click [OK]

That will handle the magnitude issue.

If you custom number format A1:D1 to 0000, then the cells will also appear in military format.

Does that help?

Ron