Comparing column values

Hello,

I have an worksheet with over 1000 rows. For each row, there are numbers in
4 columns. Column A should be the lowest number for each row, with each
subsequent column being a higher number as you read across for each row.
I've stumbled across a few errors and now I'm worried there are more errors.
Is there a way to automatically check and see if cell A1 is a smaller number
than B1, and B1 is smaller than C1, and C1 is smaller than D1 (and continue
this for all rows)? Having to do this manually for as many rows as I have
would take forever and I'm sure I could easily glare over a mistake. Thanks
for the help.

Mark

There (at least) 1 way to do this. Use Conditional Formatting to highlight
any row that fails your conditions.

Select the 4 cells in the first row of your data - let's say it is row 2 -
then go to Format->Conditional Formatting. Choose 'Formula is" and use the
formula
=or($A2>$b2,$b2>$c2,$c2>$D2)

Then click on the Format button. Click on the Pattern tab and choose a
highlight color. OK your way back to Excel. Copy the 4 cells, select the
entire data range and use Edit->Paste Special->Formats.

Now any row that fails to meet your conditions will be highlighted




"Mark Christensen" wrote:

> Hello,
>
> I have an worksheet with over 1000 rows. For each row, there are numbers in
> 4 columns. Column A should be the lowest number for each row, with each
> subsequent column being a higher number as you read across for each row.
> I've stumbled across a few errors and now I'm worried there are more errors.
> Is there a way to automatically check and see if cell A1 is a smaller number
> than B1, and B1 is smaller than C1, and C1 is smaller than D1 (and continue
> this for all rows)? Having to do this manually for as many rows as I have
> would take forever and I'm sure I could easily glare over a mistake. Thanks
> for the help.
>
> Mark
>
>
>

Thanks! That worked great.


"Duke Carey" <DukeCarey@discussions.microsoft.com> wrote in message
news:70B1093F-AA05-4591-A723-A4F18FC7A62B@microsoft.com...
> There (at least) 1 way to do this. Use Conditional Formatting to
> highlight
> any row that fails your conditions.
>
> Select the 4 cells in the first row of your data - let's say it is row 2 -
> then go to Format->Conditional Formatting. Choose 'Formula is" and use
> the
> formula
> =or($A2>$b2,$b2>$c2,$c2>$D2)
>
> Then click on the Format button. Click on the Pattern tab and choose a
> highlight color. OK your way back to Excel. Copy the 4 cells, select the
> entire data range and use Edit->Paste Special->Formats.
>
> Now any row that fails to meet your conditions will be highlighted
>
>
>
>
> "Mark Christensen" wrote:
>
>> Hello,
>>
>> I have an worksheet with over 1000 rows. For each row, there are numbers
>> in
>> 4 columns. Column A should be the lowest number for each row, with each
>> subsequent column being a higher number as you read across for each row.
>> I've stumbled across a few errors and now I'm worried there are more
>> errors.
>> Is there a way to automatically check and see if cell A1 is a smaller
>> number
>> than B1, and B1 is smaller than C1, and C1 is smaller than D1 (and
>> continue
>> this for all rows)? Having to do this manually for as many rows as I
>> have
>> would take forever and I'm sure I could easily glare over a mistake.
>> Thanks
>> for the help.
>>
>> Mark
>>
>>
>>