software

I have a set of values between R123:V123 I'm tring to write a formula that
will show the value in S123 only if it is above the value in R123 and if not
then leave blank.

Use conditional formatting with a formula of

=S123lt;=R123

and set the font colour to white.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;trav2016quot; gt; wrote in message
...
gt; I have a set of values between R123:V123 I'm tring to write a formula that
gt; will show the value in S123 only if it is above the value in R123 and if
not
gt; then leave blank.

How are you getting the numbers into those cells? If you're pulling
them in through a formula or function, you can include an IF() function
to stop it from loading into the cell:

=IF(x1gt;r23,x1,quot;quot;)

If you just don't want to see the number, you can use Conditional
Formatting. You can set the font color to the background color if the
Cell Value condition is met.

HTH

Bruce--
BruceP
------------------------------------------------------------------------
BruceP's Profile: www.excelforum.com/member.php...oamp;userid=33653
View this thread: www.excelforum.com/showthread...hreadid=536902Thank you but I was hoping of just getting the value and not a quot;truequot; or
quot;falsequot; and to leave blank if the value is then the value in R123

quot;Bob Phillipsquot; wrote:

gt; Use conditional formatting with a formula of
gt;
gt; =S123lt;=R123
gt;
gt; and set the font colour to white.
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;trav2016quot; gt; wrote in message
gt; ...
gt; gt; I have a set of values between R123:V123 I'm tring to write a formula that
gt; gt; will show the value in S123 only if it is above the value in R123 and if
gt; not
gt; gt; then leave blank.
gt;
gt;
gt;

Sorry for being unclear, I'm tring to have a value from R123:V123 show in
another diagram between B176:F176 but, I want only values from S123:V123 that
are greater then the value in R123 to show in C176:F176. B176 would have the
value equal to R123. If the value between S123:V123 is less then R123 I would
like to leave it blank in the diagram of C176:F176.

quot;BrucePquot; wrote:

gt;
gt; How are you getting the numbers into those cells? If you're pulling
gt; them in through a formula or function, you can include an IF() function
gt; to stop it from loading into the cell:
gt;
gt; =IF(x1gt;r23,x1,quot;quot;)
gt;
gt; If you just don't want to see the number, you can use Conditional
gt; Formatting. You can set the font color to the background color if the
gt; Cell Value condition is met.
gt;
gt; HTH
gt;
gt; Bruce
gt;
gt;
gt; --
gt; BruceP
gt; ------------------------------------------------------------------------
gt; BruceP's Profile: www.excelforum.com/member.php...oamp;userid=33653
gt; View this thread: www.excelforum.com/showthread...hreadid=536902
gt;
gt;

ok Im an idiot, here's the formula I need =IF(B176lt;=S123,S123,quot; quot;) I wrote it
wrong the first time( no space between the quot; marks) Thanks for your help.

quot;trav2016quot; wrote:

gt; I have a set of values between R123:V123 I'm tring to write a formula that
gt; will show the value in S123 only if it is above the value in R123 and if not
gt; then leave blank.

You can't do that since you are referring to the same cell that holds the
formula, I don't you understood Bob's answer,. he suggested you use
formatgt;conditional formatting and formula is, then select a white font
That way it won't be visible--

Regards,

Peo Sjoblom

nwexcelsolutions.com
quot;trav2016quot; gt; wrote in message
...
gt; Thank you but I was hoping of just getting the value and not a quot;truequot; or
gt; quot;falsequot; and to leave blank if the value is then the value in R123
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt;gt; Use conditional formatting with a formula of
gt;gt;
gt;gt; =S123lt;=R123
gt;gt;
gt;gt; and set the font colour to white.
gt;gt;
gt;gt; --
gt;gt; HTH
gt;gt;
gt;gt; Bob Phillips
gt;gt;
gt;gt; (remove nothere from email address if mailing direct)
gt;gt;
gt;gt; quot;trav2016quot; gt; wrote in message
gt;gt; ...
gt;gt; gt; I have a set of values between R123:V123 I'm tring to write a formula
gt;gt; gt; that
gt;gt; gt; will show the value in S123 only if it is above the value in R123 and
gt;gt; gt; if
gt;gt; not
gt;gt; gt; then leave blank.
gt;gt;
gt;gt;
gt;gt;