conditional formatting macro

[JRS]

I'm trying to get a macro to operate on a select amount of data, to do this I'm need to find a way of getting excel to select every row, where the first letter of the code in column C starts with the letter N.

Anyone know how I can do this?
Is it possible?

 

[Trevor G]

Add a filter to use Begins with and then use the letter N, you will then see a filtered list of data that begins with N.

What are the conditions?