Multiple conditioning formatting

[NoooC]

Hi,

I'm struggling with excel and conditioning formatting. I want to highlight a cell based on two conditions but I don't know how.

The result should be like this (because I don't have the permissions to add attachments, I've created a visual with a table):

This is my Excel-sheet
[table="width: 500, class: grid"]
[tr]
[td][/td]
[td]A[/td]
[td]B[/td]
[td]C[/td]
[td]D[/td]
[td]E[/td]
[td]F[/td]
[td]G[/td]
[/tr]
[tr]
[td]1[/td]
[td]Carl[/td]
[td]11[/td]
[td]14[/td]
[td]14[/td]
[td][/td]
[td]Bonus:[/td]
[td]20[/td]
[/tr]
[tr]
[td]2[/td]
[td]Daisy[/td]
[td]9[/td]
[td]19[/td]
[td]20[/td]
[td][/td]
[td][/td]
[td][/td]
[/tr]
[tr]
[td]3[/td]
[td]Frank[/td]
[td]16[/td]
[td]10[/td]
[td]14[/td]
[td][/td]
[td][/td]
[td][/td]
[/tr]
[tr]
[td]4[/td]
[td]Jade[/td]
[td]20[/td]
[td]8[/td]
[td]14[/td]
[td][/td]
[td][/td]
[td][/td]
[/tr]
[tr]
[td]5[/td]
[td]John[/td]
[td]8[/td]
[td]12[/td]
[td]13[/td]
[td][/td]
[td][/td]
[td][/td]
[/tr]
[tr]
[td]6[/td]
[td]Pete[/td]
[td]14[/td]
[td]16[/td]
[td]11[/td]
[td][/td]
[td][/td]
[td][/td]
[/tr]
[tr]
[td]7[/td]
[td]+15[/td]
[td]2[/td]
[td]2[/td]
[td]0[/td]
[td][/td]
[td][/td]
[td][/td]
[/tr]
[tr]
[td]8[/td]
[td]Bonus[/td]
[td]1[/td]
[td]0[/td]
[td]1[/td]
[td][/td]
[td][/td]
[td][/td]
[/tr]
[/table]

What do I want?
I want to highlight the cells in row 8 IF

1. The value of the current cell is 1 (It's 1 when the value of "bonus" (cell: G1) is in the range of the column)
2. The value of the cell above must be greather than 1

So:
B8 is highlighted because: B8 = 1 AND B7 > 1
C8 is not highlighted because: C8 is not 1
D8 is not highlighted because: D7 is not greather than 1

I have the formulas to calculate the value of the cells but don't know how to add the conditional formatting based on this two conditions...

I hope what I have requested is possible.

 

[AliGW]

Formula for CF in B8:

=AND(B8=1,B7>1)

Then copy formatting of B8 to C8 and D8.

 

[NoooC]

Thank you!

Is this also possible for a range and not cell by cell? Because I have more than 3 columns (+/- 50)

 

[AliGW]

Yes: just change the range in the CF formatting dialog. You can add non-contiguous ranges by separating them with a semi-colon ( ; ). The formula uses relative cell references, of course.

 

[NoooC]

Oh right, thanks!