I'm trying to get an excel invoice to recognize negative numbers. I only have one condition running and it is "cell value is between -1000 and 1000" the format of the cell is currency, but it's still not recognizing negative numbers. can anyone help please!!!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
help with conditional formatting
- Thread starter IOTP
- Start date
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,289
- Office Version
- 365
- Platform
- Windows
Are you sure your value is entered as a number and not text?
For example, if the cell in question is A1, does the following formula return TRUE?
=ISNUMBER(A1)
If not, your value is entered as TEXT and that is why it is not working.
For example, if the cell in question is A1, does the following formula return TRUE?
=ISNUMBER(A1)
If not, your value is entered as TEXT and that is why it is not working.
Upvote
0
Excel Facts
Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
jimbojones
Well-known Member
- Joined
- Apr 22, 2002
- Messages
- 776
Wow...got there in the end!!!
Upvote
0
