Hide font in formula

  • Thread starter Thread starter gavmer
  • Start date Start date
G

gavmer

HI Tom,

Thanks for the reply. Prob is, this shows no value. The user inputs a
qty in G1 which returns a value to b1, based on a price in a1. I dont
want the user to see the end value but would like something to show
that a value exists. If nothing, then nothing shows. Maybe code that
states if the cell value is >1, then the cell colours????

Thanks Tom!!!
 
if b1 has a value and I want to see it, I can go to another cell and do

=B1

If you want to color the font or the color, use conditional formatting.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide font in formula 1
"DoEvents"-type behavior in Solver? 1
Can a formula do this? 1
Excel Need Countifs Formula Help 0
A data validation question 1
Hiding and unhiding rows 8
Hiding secret formulas 1
Scrabble Value calculation for Welsh words 0

Back
Top