Conditional Format "ending with..."

[wisdomprofits]

I need to add some conditional formatting so that numbers/text in a column, ending with 30 and 60, get highlighted with different colors. (30's with green, 60's with orange). I'm assuming I would contruct one formula for each color.
How do I construct the formulas?

 

[Seti]

You could use something like this (assuming the cell you are interested in is A1)

RIGHT(A1,2)="30"

or

RIGHT(A1,2)="60"

 

[wisdomprofits]

Forgive me. I'm an excel newbie...

I'm trying to format all the cells in column B in this exercise.

Would I select "Conditional Formatting", then select "Highlight Cell Rules", then select "Equal to..", and then enter the formula in the text box?

I tried the formula you suggested and nothing happened...I'm guessing I did something wrong. Thank you for you help!

 

[T. Valko]

I need to add some conditional formatting so that numbers/text in a column, ending with 30 and 60, get highlighted with different colors. (30's with green, 60's with orange). I'm assuming I would contruct one formula for each color.
How do I construct the formulas?

What kind of numbers are these? Are they all integers (whole numbers)?

Can you post several examples?

Also, what version of Excel are you using?

 

[Steve=True]

First Highlight your entire column of data containing the 30 or 60.

Then select conditional formatting.

I usually choose new rule

Then "Use a formula to determine which cells to format"

Make sure you put an = sign to the left of the formula.

change d1 below to the first cell in your column or range

=RIGHT(D1,2)="30"
choose formating you want click oka and then apply.

repeat for
=RIGHT(D1,2)="60"

Steve=True
www.exceldashboardtemplates.com

 

[mikerickson]

Rather than using string functions with numbers (which might cause problems)
you could use = (MOD(D1, 100)=30) and =(MOD(D1,100)=60)