what charactor to hold number space in conditional formating

D

Duane Hookom

Is there a question here? Your Subject doesn't make much sense to me.

Please feel free to use the body of your posting to fully describe your
situation and question.
 
F

fredg

This is the area of your message where you're supposed to ask a
question, not the subject line.
Besides which, your subject line does not make much sense.
Why not try again and spend a bit of time explaining what you mean.
 
F

fpb34

fredg said:
This is the area of your message where you're supposed to ask a
question, not the subject line.
Besides which, your subject line does not make much sense.
Why not try again and spend a bit of time explaining what you mean.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Sorry guys first time. what I am asking is when using conditional formating in a report, what charactor could I use in a 5 digit number to only use the conditons on the last 2 numbers?
Click to expand...
 
D

Duane Hookom

If the 5 digit number is text then
Expression Is
Right([YourFieldExpression],2) = "__"
If numeric, consider
Right(str([YourFieldExpression]),2) = "__"
 
Top