How to make sure each cell has bigger number than previous

M

Mark Christensen

Hello,

I have a price list that has 4 columns of pricing for each part number (we
have 4 levels of distribution). The price in column C should be less than D;
D should be less than E; E should be less than F; and F should be less than
G. There are over 1500 rows in this price list, so doing this be eye is not
really feasible. Is there a way I can automate this process and have Excel
flag any cells that don't follow the above rule? Thanks.

Mark
 
B

Bob Phillips

Use conditional formatting with a formula in say c2 of

=C2<D2


--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
M

Mark Christensen

So in the conditional formatting dialog box, what exactly would I enter in
the 3 boxes? I tried Cell Value is Less Than =A2<B2<C2<D2 but it only
appears to be checking the 1 cell.
 
L

L. Howard Kittle

Hi Mark,

I'm a bit confused with Bob's solution, but he's way good at this stuff.

Try this. Select column C and then Format > Cond Format > Formula is >
"=C1>D1" (no quotes) > Format > Patterns > select a color > OK > OK.

Now if C1 is greater than D1 it will show your color.

Do the same for all the other columns... =D1>E1, etc.

HTH
Regards,
Howard
 
B

Bob Phillips

Change Condition 1 from Condition Is to Formula Is. The formula should
actually be =C2>D2 and format on that condition, i.e the error

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
M

Mark Christensen

OK, got it. Thanks.

Bob Phillips said:
Change Condition 1 from Condition Is to Formula Is. The formula should
actually be =C2>D2 and format on that condition, i.e the error

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
Click to expand...
 
Top