Shade cells which have values in the bottom 20% of a table

[mhah]

I have the following table in my spreadsheet. I'm trying to shade those cells with values in the bottom 10% (bottom decile) of those values in pink colour, and those cells with values in the 10-20% (next bottom decile) in orange colour. Appreciate any help with this - thanks.

[TABLE="width: 50"]
<TBODY>[TR]
[TD]28%[/TD]
[/TR]
[TR]
[TD]23.6%[/TD]
[/TR]
[TR]
[TD]29.5%[/TD]
[/TR]
[TR]
[TD]16.5%[/TD]
[/TR]
[TR]
[TD]17.7%[/TD]
[/TR]
[TR]
[TD]23.1%[/TD]
[/TR]
[TR]
[TD]67.8%[/TD]
[/TR]
[TR]
[TD]43.2%[/TD]
[/TR]
[TR]
[TD]6.8%[/TD]
[/TR]
[TR]
[TD]28.4%[/TD]
[/TR]
[TR]
[TD]12.7%[/TD]
[/TR]
[TR]
[TD]14.3%[/TD]
[/TR]
[TR]
[TD]12%[/TD]
[/TR]
[TR]
[TD]15%[/TD]
[/TR]
</TBODY>[/TABLE]

 

[Gary's Student]

See:

Shade cells which have values in the bottom 20%