Maman

How about 6 colors without using code?

JE McGimpsey points out a method of combining CF and Custom format.

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


Gord Dibben Excel MVP

On Mon, 7 Feb 2005 12:03:03 -0800, "Manan"
wrote:

Hi
I am new to conditional formating in Excel.

In row 2 I need to enter nos. between 1-5. I want each color to have a
particular color. I have managed to do 4 (3 with conditional formating and
the 4th retaining the default color).

Is there a way i can do all 5 colors?

Thanks