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 every A1 B1 , A2 B2 , ...

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

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

Could you help me do this?

Answer 1

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

Maybe a little late :)

NTN!