conditional format to last digit

[rikvny02]

Hello All
I'd like to conditional format a cell if the last digit in the cell is not .05 or .00
ex. 12.23 would be highlighted.

Any help would be very grateful.

Thanks

 

[Candyman8019]

Try highlighting using a formula like this.

=AND(RIGHT(E15,2)<>"00",RIGHT(E15,2)<>"05")

note: change the cell refrences to match your sheet.

 

[rikvny02]

Try highlighting using a formula like this.

=AND(RIGHT(E15,2)<>"00",RIGHT(E15,2)<>"05")

note: change the cell refrences to match your sheet.

Thanks for your reply.

I need to rephrase my question. I need to highlight any number that does not end in 0 or 5. Meaning the second decimal place. ex. 1.23 would be highlighted but 1.25 would not.

Sorry for being difficult.

 

[Candyman8019]

Give this formula a try:
=E15-0.05*INT(E15/0.05)

again changing cell references accordingly...

 

[rikvny02]

Give this formula a try:
=E15-0.05*INT(E15/0.05)

again changing cell references accordingly...

Work like a charm. Thank u

 

[smozgur]

Work like a charm. Thank u

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers.
No further action is required for this thread.