Words are >0 to Excel.
Dates are actually numbers, so they are all >0 to Excel.
What is the range of numbers we're dealing with here? The numeric values for dates since 1960 are all 20000 and higher... so if the values you're wanting to test for being greater than a certain number could never reach that high, it would be simple to add a LESS than value as well.
Condition1: Formula:
=AND(A1>=50, A1<=22000, NOT(ISTEXT(A1))
Last edited by JBeaucaire; 02-28-2014 at 04:06 PM.
_________________
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!)
here is a test worksheet of what is happening.
it is a car part life sheet to keep track of mileage on certain parts. there is about 450 rows to fill.
so parts will have the name at left and then a description or date installed above the current mileage on that part
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks