First post!
I searched/read as many posts as I could but could not find that matching my problem.
I have a work sheet that uses allot of =if() and =choose() formulas. Based on what a cells value is though I would like that to determine the number of decimal places shown in unlocked(manual entry) and locked (calculated) cells. I have 15 different cell values (cases) that need to be broken into 4 different decimal digit possibilities (0,2,3 and 4 digits).
Example1: Cell A1=Case1 or Case2 or Case3 or Case4; Cells GHI28, JKL28 and MNO28 will have 0 digits displayed after decimal place.
Example2: Cell A1=Case5 or Case6; Cells GHI28, JKL28 and MNO28 will have 2 digits displayed after decimal place.
Additionally I am doing this across 20 rows, so will have 20 triggers cells (one for each row) and formatting 60 cells (3 per trigger cell)
I know that this can't be done in "Conditional formatting" but can be done in VBA, if one could be so kind as to assist me with the VBA code need to achieve my desired request I would greatly appreciated it.
I hope that my explanation is clear enough to assist you in assisting me.
Thanks in advance and have a nice day.
I searched/read as many posts as I could but could not find that matching my problem.
I have a work sheet that uses allot of =if() and =choose() formulas. Based on what a cells value is though I would like that to determine the number of decimal places shown in unlocked(manual entry) and locked (calculated) cells. I have 15 different cell values (cases) that need to be broken into 4 different decimal digit possibilities (0,2,3 and 4 digits).
Example1: Cell A1=Case1 or Case2 or Case3 or Case4; Cells GHI28, JKL28 and MNO28 will have 0 digits displayed after decimal place.
Example2: Cell A1=Case5 or Case6; Cells GHI28, JKL28 and MNO28 will have 2 digits displayed after decimal place.
Additionally I am doing this across 20 rows, so will have 20 triggers cells (one for each row) and formatting 60 cells (3 per trigger cell)
I know that this can't be done in "Conditional formatting" but can be done in VBA, if one could be so kind as to assist me with the VBA code need to achieve my desired request I would greatly appreciated it.
I hope that my explanation is clear enough to assist you in assisting me.
Thanks in advance and have a nice day.