Displaying remaining balance in cells w/o formulas

[DashboardNovice]

In the attached spreadsheet, the user would enter a percentage in cells I7, I9 and I11. The values in column L will calculate the remaining percentage balance. However, I would like the results in column L to appear in column I which would appear as a default before the user enters a value, so that way they know the percentage left that they can use.

But if I enter the formulas to calculate the remaining % balance in column I, the user would overwrite those formulas when they enter a value for a percentage.

So basically, before the user enters values in column I, each cell would display the remaining percentage as a default in gray fonts (just like what is showing in column L). I am trying to find a way to display the default value w/o actually entering a formula in the cells in column I.

I'm thinking that conditional formatting may be the answer in the sense that conditional formatting can format the way a cell looks w/o the user having to select the actual cell. I want to do this w/o VBA.

Is there a way to do this?

 

[NARAYANK991]

Hi ,

I doubt that CF can do what you want to do , especially because in the second and third cells , the possible amount depends on what has been entered in the previous cell(s) ; this means that the CF for the second cell has to consider the value in the first cell to change what is displayed in the second cell.

VBA would make it very easy.

Narayan