Highlight entire row if last string has even number at the end of text, using excel function or vba.

[Astronaut01]

Hi experts, basically i have dynamic entries in col A, eg.. hrr-101, hrr-102. I need to highlight entire row if theres an entry ending with even number, by just using excel formula. If not, vba is ok. Thanks for your answers.

 

[arthurbr]

Hi
select your entire range ( not only col A) and use the following as Conditional Formatting formula

=MOD(RIGHT($A1,LEN($A1)-FIND("-",$A1))+0,2)=0

Format as required

 

[Astronaut01]

Hi
select your entire range ( not only col A) and use the following as Conditional Formatting formula

=MOD(RIGHT($A1,LEN($A1)-FIND("-",$A1))+0,2)=0

Format as required

Hi arthurbr
It is working now. However, how can i make the formula to highlight the entire rows by just depending on the last digit as odd or even? Like a dynamic entries in col A? Thank you again for the answer on this one.

 

[Fluff]

To just use the last digit you can use

=MOD(RIGHT($A1)+0,2)=0

 

[Joe4]

Or just use the ISEVEN function, i.e.

=ISEVEN(RIGHT($A1,1))