Prev: Send worksheet as HTML email
Next: Change the values of cells by a fixed factor i.e. 10/100= 0.10
From: Sandusky on 2 Jun 2010 10:22
Windows XP Pro SP3
Excel 2007

Suppose cells A1:A10 contain integer values. Now suppose cells B1:B10
also contain integer values. I'd like to conditionally format the
values in column B so that if the value in column B is greater than
100% of the value in column A then the B cell is shaded red. If the
value in column B is greater than or equal to 75% but less than 100%
of the value in column A then the B cell is shaded yellow. If the
value in column B is less than 75% of the value in column A then the B
cell is shaded green. Is this possible?

A B
=============
20 18 <-- shaded yellow
50 10 <-- shaded green
75 81 <-- shaded red
From: Tom-S on 2 Jun 2010 16:24
You can use the Conditional Formatting feature.

Click in target cell (B1), then click Format>Conditional Formatting.

Under Condition 1 have 'Cell Values Is', then 'greater than', then =B2, then
click the Format button and on the Patterns tab select the red shade, and
click OK.

Back at the Conditional Formatting dialogue, click Add>> and a Condition 2
set of boxes appear. Set these to 'Cell Value Is', between, =0.75*B2, and
=B2, then select the yellow shading.

Add>> again and set Condition 3 as 'Cell Value Is', less than, =0.75*B2,
then select the green shading, and OK twice.

Finally copy cell B1 (Ctrl + C), then highlight cells B2:B10, right click,
select Paste Special>Formats.

That should do it.

Regards,

Tom



"Sandusky" wrote:

> Windows XP Pro SP3
> Excel 2007
>
> Suppose cells A1:A10 contain integer values. Now suppose cells B1:B10
> also contain integer values. I'd like to conditionally format the
> values in column B so that if the value in column B is greater than
> 100% of the value in column A then the B cell is shaded red. If the
> value in column B is greater than or equal to 75% but less than 100%
> of the value in column A then the B cell is shaded yellow. If the
> value in column B is less than 75% of the value in column A then the B
> cell is shaded green. Is this possible?
>
> A B
> =============
> 20 18 <-- shaded yellow
> 50 10 <-- shaded green
> 75 81 <-- shaded red
> .
>
 | 
Pages: 1
Prev: Send worksheet as HTML email
Next: Change the values of cells by a fixed factor i.e. 10/100= 0.10