Hide Dollar Amounts in Excel Columns

Hello Experts -

I was wondering if it possible to hide the dollar amounts in columns C18, F18, D23, E21, E22, and F18 - F23. my client doesn't need to see those just the numbers in BOLD.

And I will have to repeat this for all nodes that are bold.

See the attachment below.

Thanks in advance,
GeneBat
blank-dollar-amts.JPG
GeneBatAsked:
Who is Participating?
 
Elton PascuaCommented:
Can't you just make the font white? Or uncheck it as a column category?
0
 
JohnBusiness Consultant (Owner)Commented:
IF(something = BOLD, action) is not a test so far as I know in Excel. So I don't think you can do what you want directly.

I looked at your sheet and I think you would have to add an indicator column to control the display.

Alternatively, re-design the sheet so that dollars are in a separate column and hide the column. This is probably the best approach.

.... Thinkpads_User
0
 
GeneBatAuthor Commented:
Sometimes it's the simple’s things. Change the font to white works for me.

Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.