Numerical or text data?

If numerical JE McGimpsey has a method of formatting for up to 6 conditions.

http://www.mcgimpsey.com/excel/conditional6.html


Gord Dibben MS Excel MVP

On Wed, 15 Nov 2006 18:21:02 -0800, Dave Ah Ching <Dave Ah
wrote:

I am using Conditional Formatting to color a cell automatically.
Unfortunately using this method I am limited to 3 colours. Is there another
way to expand the color limit. I need to use 5 color options.