Conditional Formatting based on last digit

[johnsnyder7]

I have a very large table of values that all end in either ".0" or ".5" and want to use conditional formatting to change the color of all the cells with values ending in ".5".

Could anyone shed light on this for me?

Thank you,
John

[dominicb]

Good afternoon johnsnyder

...and welcome to the forum!!

I have a very large table of values that all end in either ".0" or ".5" and want to use conditional formatting to change the color of all the cells with values ending in ".5".

Go to :

Format > Conditional Formatting
Formula Is
=RIGHT(C8,2)=".5" Change C8 to the first cell address in your range.
Select your format.
Click OK.

Now use your format painter tool (little paintbrush icon - standard toolbar) to apply the conditional formatting to all items in your range.

HTH

DominicB

[johnsnyder7]

Dominic,

Thanks very much for your help!