Conditional formating for two columns

[zoinc]

I can't sleep, this is driving me nuts


[TABLE="width: 475"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD="align: left"]Dieter Adriaensen[/TD]
[TD="align: left"] € 4,820.40[/TD]
[/TR]
[TR]
[TD="align: left"]Sammy Bogaert[/TD]
[TD="align: left"] € 3,716.60[/TD]
[/TR]
[TR]
[TD="align: left"]Griet Coostermans[/TD]
[TD="align: left"] € 2,190.90[/TD]
[/TR]
[TR]
[TD="align: left"]Andy Peeters[/TD]
[TD="align: left"] € 3,170.49[/TD]
[/TR]
[TR]
[TD="align: left"]Lieve Van den Heuvel[/TD]
[TD="align: left"] € 5,320.75[/TD]
[/TR]
[TR]
[TD="align: left"]Steve Wilssens[/TD]
[TD="align: left"] € 4,130.20[/TD]
[/TR]
[TR]
[TD="align: left"]Average[/TD]
[TD="align: left"] € 3,891.56[/TD]
[/TR]
</tbody>[/TABLE]
I need to:
[TABLE="width: 729"]
<colgroup><col><col span="10"></colgroup><tbody>[TR]
[TD="colspan: 11, align: left"]Highlight the names and the amounts in blue if the amount is below the average.[/TD]
[/TR]
[TR]
[TD="colspan: 11, align: left"]Highlight the names and the amounts in red if the amount is 15% above the average.

What I managed to do:
Highlight the amounts below the average in blue (never the names)
I am losing my mind....

Thanks a LOT!!!![/TD]
[/TR]
</tbody>[/TABLE]

 

[JoeMo]

Welcome to the board!

Supposing Dieter is in A1 and his amount in B1 for the sample data you posted, do the following:

1. Select A1:B6 with your mouse.
2. Home>Conditional Formatting>New Rule>Use a formula.
3. For below average formula is: = $B1 < $B$7
4. Choose format (blue fill)
5. Press OK
Repeat these steps for 15% above the average using this formula: =$B1 > 1.15*$B$7 and choose a red fill.

 

[63falcondude]

Assuming that your data is in A1:B7, try the following:

Highlight A1:B6 > Conditional Formatting > New Rule > Use a formula

=$B1<$B$7

Format: Fill blue > OK > OK

Highlight A1:B6 > Conditional Formatting > New Rule > Use a formula

=$B1>=1.15*$B$7

Format: Fill red > OK > OK

Edit: Joe beat me to it.

 

[zoinc]

JoeMo, 63Falcondude

It worked !
I am faithful to this board as long as I live.THANK YOU

P.S-JoeMo beat you by one minute

 

[JoeMo]

JoeMo, 63Falcondude

It worked !
I am faithful to this board as long as I live.THANK YOU

P.S-JoeMo beat you by one minute

You are welcome - thanks for the reply.