Hi all,

Small problem. Have a formula in a cell =a1*g1. Problem is I dont wan

the value when selected to show. I would accept the cell showing "Inc

or even changing colour but the value cannot show as it is a price.

Can anyone please help??

Cheers!!

format => cells => Number Tab, select custom

use ;;;

for the format.

--

Regards,

Tom Ogilvy

http://www.yqcomputer.com/

use ;;;

for the format.

--

Regards,

Tom Ogilvy

http://www.yqcomputer.com/

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!!!

--

gavmer

------------------------------------------------------------------------

gavmer's Profile: http://www.yqcomputer.com/

View this thread: http://www.yqcomputer.com/

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.

--

regards,

Tom Ogilvy

http://www.yqcomputer.com/

=B1

If you want to color the font or the color, use conditional formatting.

--

regards,

Tom Ogilvy

http://www.yqcomputer.com/

Hi Tom,

The easiest solutions are often forgotten. Thank you very much!!

Cheers!

1. Entering Formula - Cannot select cell as it is hidden by formula

2. how do I hide a cell formula from the formula bar

3. Way to hide text without hidden text font?

4. Show Formula / Hide Formula

5. Hiding Formulas In Cells Not Formula Bar

6. How to view a hidden/protected formula in Excel /showing a formula

7. Protect individual cell and hide formula in formula bar

8. Hiding Formulas in Formula bar

9. Hide or delete "Add-Ins" in ribbon

10. ac2007, hide "home", "add-ins" menu items

11. Darren Liu blog hiding views in crm 4.0 using plug-ins

12. How to use Add Ins / Formula Colours

13. Are there any advanced formula error checking add-ins for Excel?

14. Add-Ins for Excel 2003 - Financial Formulas does not download

15. MCE 2005 Add-ins and Screen Fonts...?

5 post • Page:**1** of **1**