Conditional Formatting

[pjn560]

Can you do conditional formatting on a column based on last number in each cell.

I need to highlight all cells that end with a 6 in a particular column.

Thanks

 

[njimack]

=right(A1)="6"

 

[Fluff]

Select the column from the first row of data to the last & use a formula
=RIGHT(H2)="6"

Change H2 to the first cell you selected.

 

[pjn560]

Thanks, works great.

 

[Fluff]

Glad we could help & thanks for the feedback