Hi all,
I have a cell with a drop down menu in which a user chooses what unit they are working in.
Hours, Days or Weeks.
Then I have another cell in which the user enters a number.
I want the number entered to be automatically formatted according to the unit specified by the user.
Eg.
Unit Number
Hours 8 Hours (User entered only the number 8)
Days 8 Days (User entered only the number 8)
Weeks 10 Weeks (user entered only the number 10)
Your help is much appreciated.
Cheers.
You can conditionally format colors and fonts and borders, but not text, not in the same cell.
The only thing I can think of is you'll have to design a Worksheet_Change macro that will change the custom number formatting applied to the adjacent cells. Seems like a lot of work.
If you just use 3 cells, it's easy.
A1 = Days
B1 = 8
C1 =B1 & " " & A1
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
av_ace11 
Register To Reply
Bookmarks