I have a cell where I need this to happen:
- If inputted value is < 0, do not allow
- If inputted value is less than ten (eg: 2) show as percentage (eg: 2%)
- If inputted value is greater than 10, show as a number (eg: 1,250)
I cannot figure this out for the life of me.
Last edited by agalloch123; 05-15-2014 at 12:47 PM. Reason: SOLVED
For Urgent matters see the commercial forum
Not immediatley urgent, but would be VERY helpful.
Hi and welcome to the forum
for the DV use aA1>0
I dont think you can do the % with DV, because if you enter a whole number into a cell, say 5, that will actually be 500%. You will probably need to do a calc in a helper cell and try CF onthat
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
But even if I do something simple like this:
Conditional Format 1
=A1*100<10
...make it a percentage
It NEVER works. Not sure why.
Figured it out:
Custom Number Format:
[<=10]0\%;[>10]0
CF does just that - it changes the FORMAT of a cell. Formatting is not data, it is cosmetic, it cannot change the underlying contents of a cell, only how they display
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks