Discussion Locked

Change the display of an excel formula

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a formula in an excel spreadsheet that I only want to display when it is greater than the cell above it.
Is there a way to tell the formula not to display if it is equal to or less than the cell above it?
Thank you
Edith

4 replies

by dklippert

Try some variation of this formula"
=IF(B3*B4>A1,B3*B4,"")
If the formula result is greater than the value in A1 then show the result of the formula. Else show nothing ""

by jmcorn01

Typically this is handled using Conditional Formatting. Select the cell in question, then set the Font color to match the background color of the cell. Next, click FORMAT - CONDITIONAL FORMATTING. This will open a dialog box where you can specify the conditions for which you want something to happen. Specify The Cell Value is greater than {add cell number above}. Next click the Format... button and change the Font color. Now the cell will "appear" empty if the condition is NOT met but willshow the results of the formula when the condition IS met.

This discussion is closed to new replies.