David, The conditional formatting worked well for Column N Total dose for 76 cells, then I started having problems getting the VBA to run. In order to run the VBA I have to manually run it. If I read and understand that in the user cells I cannot use this conditional formatting in unlocked cells. How can I use this same principal for the user cells which are in Column K without losing a formula for the decimal places.
Also the formula you suggested for N column for the additional 0.125 is a constant addition of the fats and skinny's which is not always used with each dose. It can be used by itself or added to a dose when a titch more insulin would be needed.

Alright I followed your instructions and see what you are explaining. I have come to a conclusion that what I am asking may be an impossibility in excel. All the numbers except for the 1.0 or 2.0 or any numbers with a trailing zero do not replicate from Col K(trailing zero) to Col N but populate without the trailing 0. That is why I ask about a VBA that would populate Col N the same as Col K and yet use the same formula for sum up. That would give me the precision I am looking for. If Col K has 2.0 with a trailing 0 I would like Col N to be 2.0 with a trailing 0 without changing the rest of the cells with different numbers. I hope I am not straining your patience with me.

Thankyou. I have insert the new formula, but I am back to my original question. In order to keep the sum of K & L columns consistent and maybe I am being to much of a perfectionist as for excel. The 0.75, 0.5, 0.125 and the 1.0 plus (s) comes out perfect. My question would be is it possible when I type in 1.0 dose or 2.0 dose without a fat or skinny the sum does not come with 1.0 or 2.0. It sums with 1 or two and does not add that .0 I suppose that is the limitation of excel.
Col K
0.75
1.0 s

Alright I see what your saying with the formula you said would work. The problem I have with either one is the rounding. I know it seems minor but to other it can be confusing for them when precise dosing is involved and that is what I have been trying to solve which may not be possible? I am new at this so please forgive me. If a person gives 1.0IU and gives 0.125 more(which is considered a fat(f) then that one unit becomes 1.125. but if I type in S for skinny which would be 0.125 less of the 1UI it adds the 0.125 So the formula you sent me is reversed., so I reversed the f&s.The (f)fat subtracts the 0.125 and the (s)skinny adds 0.125. The fat should add 0.125 and the skinny should subtract the 0.125 from the main dose. Now if I just dose a "s" or "f" which would be 0.125 it does not populate the N column with the 0.125. Am I confusing you, I hope not.

I have a lengthy explanation and thought my first question would have covered it but I did not explain properly. I have created an insulin log. Three of the columns deal with the amount of a dose. Col K Data is the original dose, lets say 0.5IU. Col L data is extra minute dose added and usually is 0.125IU. The (s )in Col L stands for skinny which means the orig dose of 0.5 less 0.125. The (f) in Col L stands for fat which means the orig dose plus 0.125 more. Col N sums the total dose of Cols K&L which can yield from one to three decimal places. These are the original dosing amounts to deal with. 0.5,0.75, 1.0,0.150. This is why I was looking for away to have Col N to be able to keep precise numbers when the dosages can use from one to three decimal places.

## My answers

David, The conditional formatting worked well for Column N Total dose for 76 cells, then I started having problems getting the VBA to run. In order to run the VBA I have to manually run it. If I read and understand that in the user cells I cannot use this conditional formatting in unlocked cells. How can I use this same principal for the user cells which are in Column K without losing a formula for the decimal places.

Also the formula you suggested for N column for the additional 0.125 is a constant addition of the fats and skinny's which is not always used with each dose. It can be used by itself or added to a dose when a titch more insulin would be needed.

Perfect. I have been asking this question for a long time and finally have the answer. Thank you for you patience and kindness.

I there and as for choosing format I suppose I should be choosing format cells for General or numbers?

Alright I followed your instructions and see what you are explaining. I have come to a conclusion that what I am asking may be an impossibility in excel. All the numbers except for the 1.0 or 2.0 or any numbers with a trailing zero do not replicate from Col K(trailing zero) to Col N but populate without the trailing 0. That is why I ask about a VBA that would populate Col N the same as Col K and yet use the same formula for sum up. That would give me the precision I am looking for. If Col K has 2.0 with a trailing 0 I would like Col N to be 2.0 with a trailing 0 without changing the rest of the cells with different numbers. I hope I am not straining your patience with me.

Thankyou. I have insert the new formula, but I am back to my original question. In order to keep the sum of K & L columns consistent and maybe I am being to much of a perfectionist as for excel. The 0.75, 0.5, 0.125 and the 1.0 plus (s) comes out perfect. My question would be is it possible when I type in 1.0 dose or 2.0 dose without a fat or skinny the sum does not come with 1.0 or 2.0. It sums with 1 or two and does not add that .0 I suppose that is the limitation of excel.

Col K

0.75

1.0 s

0.75

1.0

2.0

Col N

0.625

0.75

0.875

0.75

1

2

Alright I see what your saying with the formula you said would work. The problem I have with either one is the rounding. I know it seems minor but to other it can be confusing for them when precise dosing is involved and that is what I have been trying to solve which may not be possible? I am new at this so please forgive me. If a person gives 1.0IU and gives 0.125 more(which is considered a fat(f) then that one unit becomes 1.125. but if I type in S for skinny which would be 0.125 less of the 1UI it adds the 0.125 So the formula you sent me is reversed., so I reversed the f&s.The (f)fat subtracts the 0.125 and the (s)skinny adds 0.125. The fat should add 0.125 and the skinny should subtract the 0.125 from the main dose. Now if I just dose a "s" or "f" which would be 0.125 it does not populate the N column with the 0.125. Am I confusing you, I hope not.

I have a lengthy explanation and thought my first question would have covered it but I did not explain properly. I have created an insulin log. Three of the columns deal with the amount of a dose. Col K Data is the original dose, lets say 0.5IU. Col L data is extra minute dose added and usually is 0.125IU. The (s )in Col L stands for skinny which means the orig dose of 0.5 less 0.125. The (f) in Col L stands for fat which means the orig dose plus 0.125 more. Col N sums the total dose of Cols K&L which can yield from one to three decimal places. These are the original dosing amounts to deal with. 0.5,0.75, 1.0,0.150. This is why I was looking for away to have Col N to be able to keep precise numbers when the dosages can use from one to three decimal places.