Conditional Formatting Excel 2007

[RFJ]

Part 1

I have a series of variable numbers in Columns B, C and D (approx 100). I
want to be able to shade cells in both cols B and C when the value in the
Col C cell is greater than the value in the corresponding Col B cell.

Can it be done? If , help would be appreciated

Part 2

I also wish to do a comparison with Col B and Col D values and would wish to
have similar shading.

(As far as col B is concerned, it would shade if Col C /or/ D was bigger -
rather than both.)

Any help would be appreciated.

Tx in advance.

Rob

 

[Bernie Deitrick]

Rob,

For this answer, let's assume that your table is in cells B1100, with headers in row 1.

Select B2:B100, and (with B2 being the activecell) click
Home / Conditional Formatting / Highlight Cells Rule / More Rules... then under "Select a rule
type" select "Use a formula to determine which cells to format" and then use the formula

=OR(B2<C2,B2<D2)

and choose your format by clicking the Format button.

Then, select C2100, and (with C2 being the activecell). Again, click
Home / Conditional Formatting / Highlight Cells Rule / More Rules... then under "Select a rule
type" select "Use a formula to determine which cells to format" and then use the formula

=C2>$B2

and choose your format by clicking the Format button.

HTH,
Bernie
MS Excel MVP

 

[RFJ]

Tx Bernie,

That's great - just what I wanted <BG>

Rob