Table Formatting and Conditionnal formatting

Hello

I have a table with conditional formatting as well as formatting through table feature ( with rotating colors )

I would like to put in place the following formatting argument

Column A
Table Formatting with rotating colors

Column B
If Value > 0 Color Red
If not use table formatting with rotating colors

Column C
If Value > 0 Color Amber
If not use table formatting with rotating colors

I have tried using table formatting and conditional formatting on the same table but it is not giving the wright result...please see file attached


Any idea how to ?
Thanks

1) select all your data (A1:C14) and format it (Ctrl+1) with transparent cell bacground.
2) now you can use TAble formatting with rotating colors (if you want to have regular Excel Table - just press Ctrl+T and then change style to black header and white/gray rows.