Conditional Formatting a specific price range.

[AldoV34]

I have a data table (location across the top, product down the side) with different price showing for each combination. I'm trying to figure out a way to highlight cells that the price ends in $x.x4. Can't figure out the conditional formatting formula for it. Thanks.

[#2]

@AldoV34 

I hope your prices are numbers, not texts. The formula could be

=RIGHT(ROUND(B2,2)*100)+0=4

if B2 is top left cell of the prices range (without headers)

[#3]

Maybe I didn't make myself clear. I'm not trying to round out to "4". I'm trying to highlight a cell if the price ends in "4". $1.99 would not be highlighted, but $1.94 would be.

[#4]

@AldoV34 

That's what it do

with +0 correction to convert text to number

[#5]

Got it! Thanks.

[#6]

@AldoV34 , you are welcome