CODEWITHSUNDEEP
google-sheetsmathconditional-formatting
Jonny Hotchkiss
Jonny Hotchkiss

Reputation: 91

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

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)

rule 2 (regex)

cells

Upvotes: 0

Views: 22

Answers (2)

Jonny Hotchkiss
Jonny Hotchkiss

Reputation: 91

Adjusted the range, and referenced the first cell (b2) and it worked 👍

=mod(B2,10) = 0

enter image description here

Upvotes: 0

rockinfreakshow
rockinfreakshow

Reputation: 30281

within conditional formatting, the custom formula would be:

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

enter image description here

Upvotes: 1

Related Questions