Conditional Formatting using an If and statment

[tophat88]

Hi,

Can someone please advise me how to use conditional formatting when you want to use to conditions in the same formula. Effectively a 'And' statement.

So I want Team A below where it shows May 60% to be 'Dark Green' in conditional Formatting. The formula is in the 2nd table is the May value greater than the April Value and the 2nd part of the formula is May % of 60% greater than the April value of 50%. If both values are true format the cell Dark Green.

In Team C although the values are lower than May the % is higher in May v April so I want to show this as Light Green in the Format.

Is there a way this can be done in Excel?

Any help would be great.

Thanks


[TABLE="width: 345"]
<colgroup><col span="3"><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD]Team[/TD]
[TD]April[/TD]
[TD]May[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]A[/TD]
[TD="align: right"]50%[/TD]
[TD="align: right"]60%[/TD]
[TD]Dark Green[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]B[/TD]
[TD="align: right"]40%[/TD]
[TD="align: right"]39%[/TD]
[TD]Leave[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]C[/TD]
[TD="align: right"]55%[/TD]
[TD="align: right"]70%[/TD]
[TD]Light Green[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Team[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]A[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]50[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]B[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]51[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]C[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]40[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

Welcome to the Board!

You would use AND, i.e.
=AND(condition1, condition2)

So it might look something like:

=AND($C2>$C1,$C10>$C9)

 

[tophat88]

thanks. that was really helpful.

 

[Joe4]

You are welcome.
Note that you can have more than 2 conditions, too. I believe you can go up to 32 in AND and OR functions, in most versions of Excel.