Highlighting rows with X amount of data!

[EndZz]

I've been looking for this everywhere but I can't seem to find anything useful in helping me do what I want so I'd love some help.
What I want is for rows that have more than 15 data entries to be highlighted in green and for those that have less than 8 to be in red those in between in yellow. I would like for this to run in a macro or I could use conditional formating either way will work. Here's the closest I got, I used CF and wrote =counta(B$:P$, >10) and it should have highlighted green but no dice! I also want the yellow and red in there but I don't know if I need to put that in the macro to work thanks!

[mikellyrice]

Here is a sample XLS showing the conditional formating. By default, the color is yellow. If less than 8, it turns red. If greater than 15, it is green.

Hope this helps.

Do not understand if you are formating rows or columns. You should be able to look at the conditional formating and rearrange as needed.