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

	Team	April	May
	A	50%	60%	Dark Green
	B	40%	39%	Leave
	C	55%	70%	Light Green
	Team
	A	40	50
	B	40	51
	C	50	40

<colgroup><col span="3"><col><col></colgroup><tbody>
</tbody>

 

[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.