Depending on the contents of another cell, I want to display or not
display a value in a cell.
I have tried to do it using this script tacked onto the formula that
puts the value in the cell:
...&T(IF(A30<0; STYLE("fmtWhite"); STYLE("Default"))
Where fmtWhite has the font colour defined as White so that the value is
still there and can be used in other formulas, but cannot be seen
because it is white on white.
It works, but when I paste it into other cells where A30>0 and therefore
Default formatting applies, I lost all my currency formatting and just
get numbers, even if I redefine Default to have Numbers=Currency, or use
a different STYLE altogether.
If anyone can help me 'disappear' values when another cell has a certain
value, but without losing the formatting of cells not affected by this
condition, I would be very much obliged.
Many thanks, James
--
James Elliott BSc JP
Private mail account: [email protected]
Address: PO Box 44, Boddington WA 6390
Phone: +61 8 9883 8178 Fax: +61 8 9883 9519
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
