Use colour for specific numbers

you could use conditional format.

Below is the link to learn more about it.

http://www.contextures.com/xlCondFormat01.html

Hi Karnik,

See the attached file :-
Prime Number.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

Missed to apply the conditional formatting.. now applied, see attached:-
Prime Number.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

Here is the best way I have found to do this:

Insert this Function into a VBA Module:

Please Login or Register  to view this content.

Then highlight the entire range of cells and apply conditional formatting using this formula: =IsPrime(A1) where A1 is the first row/column in your selected range.

- Moo

I don't think so.

By Prime numbers, do you mean, 1, 3, 5, 7, 11, etc?

@ dilipandey,

Nice one. However the first two lines are wrong.

@ Moo the Dog,

Yeah, First cup of Java is only kicking in now!

Thank you.

@ dilipandey
Sorry dilipandey.

I like your approach with the Helper Column B, and the Format should look like this.

Thanks Moo for clarifying the point ..

Thanks to Winon for quick understanding and enhancing the conditional formatting

Karnik, hope your query is resolved.

Regards,
DILIPandey

<click on below 'star' if this helps>