Comparing column values

M

Mark Christensen

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
 
D

Duke Carey

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
 
M

Mark Christensen

Thanks! That worked great.


Duke Carey said:
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
Click to expand...
 
Top