G
Guest
Hello,
I am curious to know if it is possible to use the conditional formatting to
change the number formatting?
Currently, I have a sheet that is printed and mailed, but also does
calculations.
I would like to have the numbers in the calculation change between the
number formatting of “$###,###,##0â€and “### ### ##0 $†depending on what is
selected in a certain cell.
I tried, If(A1=â€Option 1â€,text(A2, “### ### ##0 $â€),text(Text,A2,
“$###,###,##0â€) but the number became text and and dependants on A2 would not
work. Give the number of cells that I would need to apply this to I was
hoping for something more global in nature.
Any suggestions would be greatly appreciated.
Thanks,
Scott
I am curious to know if it is possible to use the conditional formatting to
change the number formatting?
Currently, I have a sheet that is printed and mailed, but also does
calculations.
I would like to have the numbers in the calculation change between the
number formatting of “$###,###,##0â€and “### ### ##0 $†depending on what is
selected in a certain cell.
I tried, If(A1=â€Option 1â€,text(A2, “### ### ##0 $â€),text(Text,A2,
“$###,###,##0â€) but the number became text and and dependants on A2 would not
work. Give the number of cells that I would need to apply this to I was
hoping for something more global in nature.
Any suggestions would be greatly appreciated.
Thanks,
Scott