I'm an Excel 2003 user and attempting to conditionally format numbers using VBA. I'm struggling with the code and would love help on correctly writing the code. My situation is:
Cell D3 displays text of USD, %, or # based on the output of a formula. I have numbers in cells B6:B45 that I want displayed in the format that appears in cell D3. So, if USD appears in D3, I want the format of the numbers in B6:B45 to appear as $xx,xxx.xx. If % appears in D3, I want the format of the numbers in B6:B45 to appear as xx.xx% and if # appears in D3, I want the format of the numbers to be x,xxx.xx. Thanks for any help to this first time poster!
Cell D3 displays text of USD, %, or # based on the output of a formula. I have numbers in cells B6:B45 that I want displayed in the format that appears in cell D3. So, if USD appears in D3, I want the format of the numbers in B6:B45 to appear as $xx,xxx.xx. If % appears in D3, I want the format of the numbers in B6:B45 to appear as xx.xx% and if # appears in D3, I want the format of the numbers to be x,xxx.xx. Thanks for any help to this first time poster!