Hello,

I have two questions:

1. In column A I have data (163 rows) with billion and million (It looks like this: 1.11B, 670.93M). I want in colum B to convert everything billions. For example 1.11B to remain 1.11 billion, but 670.93M to convert to 0.67B. Which formula to use it?
2. I want ot use Conditional Formatting to color in green column J if data entered is bigger from column K and L (If data is bigger only from K or only from L, not to colored)

Thank you