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

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

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

Time：01-06

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

cells

CodePudding user response：

within conditional formatting, the custom formula would be:

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

CodePudding user response：

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