Increasing Number Sequences

[al888]

How can I get Excel to highlight columns that have an increasing number sequence?

For example, I would be looking for Excel to highlight Column 2 below

Column 1 Column 2 Column 3
24 90 76
38 80 95
67 70 24
56 65 88
54 60 43

Thanks in Advance

[teylyn]

Hello,

I would read the number sequence in column 2 as decreasing, because they get smaller when reading in normal order, i.e. top to bottom.

You can highlight all the data and (assuming the data starts in A1), use conditional formatting with a formula like

=AND(A$1>A$2,A$2>A$3,A$3>A$4,A$4>A$5)

Mind the placement of the $ signs. Of course, this approach can be rather cumbersome with large datasets.

[al888]

Thanks. Your help is very much appreciated