powerpoint table to have color scales similar to excel

[semidevil]

In excel under conditional formatting, there is a color scale option where if I highlight a table and choose a color scale, Excel will automatically highlight my cells with different shades of green, yellow and red, depending on my value.

I have a VBA code that currently copies each value in my excel table and pastes it onto a pre-made powerpoint table. Is there a way for the color to also be based with it? I just want to find a way to have powerpoint have color scales similar to excel.

For k = 3 To 6
j = 1
    For i = 2 To 7
        .Select
[B]        .Table.Cell(k, i).Shape.TextFrame.TextRange.Text = Format(ThisWorkbook.Sheets("excelsheet").Range("K17").Offset(k - 3, j - 1).Value, "0.00")[/B]
        j = j + 1
    Next i
Next k

the highlighted part above is the portion where the value of the cell in excel is 'pasted' onto the cell in the powerpoint table, and it just loops and repeats until the table is fully populated