Conditional Formatting

pjn560

New Member
Joined
Jul 29, 2015
Messages
13
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
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
38,829
Office Version
365
Platform
Windows
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.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
38,829
Office Version
365
Platform
Windows
Glad we could help & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,095,874
Messages
5,446,999
Members
405,426
Latest member
Nasty15

This Week's Hot Topics

Top