Add Google Sheets Conditionally Formatting Custom Formula rule to highlight cells that end in 0

Question

I have a table of numbers (B2:DG111)

I want to highlight the cells with values that end in 0

I tried to adjust one of the examples from this article but it's not right yet.

Currently I've selected the range and added this Format Rule

=COUNTIF(B2:DG111,mod(CN2,10)) = 0

This didn't work, also tried to achieve "not ends with" using regex (highlight if ends 1-9)

Answer 1

within conditional formatting, the custom formula would be:

=REGEXMATCH(TO_TEXT(B2),"0$")