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
<colgroup><col span="3"><col><col></colgroup><tbody>
</tbody>
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>