Thanks for your reply.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.
Work like a charm. Thank uGive this formula a try:
=E15-0.05*INT(E15/0.05)
again changing cell references accordingly...
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.Work like a charm. Thank u