On 4/25/2010 6:00 AM, James Elliott wrote:
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:
By removing the 'T" function, changing "&" to a "+', and defining a
currency style, the following would seem to do what you want.
+(IF(A30<0; STYLE("fmtWhite"); STYLE("fmtCurrency")))
TomW
