Excel : Conditional formatting

Question

I have two columns,

    **COL-A**      **COL-B**  
1      419             393
2     2199            1513
3        3               3
4       23              20
5        3               3 
4     2964            2181

I want to have conditional formatting using color scales between each A1 B1, A2 B2, ...

Currently when compared, 419 is green and 393 is red (red-yellow-green).

But the color of column B needs to be based on ratio (393/419*100=93.79%, which should be closer to green, while 10% would be closer to be red).

Could you please help me to do this?

Answer 1

I think this does the trick. Conditional format for B2 in the image.

Perhaps a bit late :)

HTH!