Comparing column values

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
>>
>>
>>