Formulas cannot format cells, only return values.

Check out FormatConditional Formatting.

You can have 3 conditions..........4 if you count the default.

If etc. means more than that, you will probably need VBA code or visit John
McGimpsey's site for Custom formatting up to 6 colors for numbers.

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


Gord Dibben MS Excel MVP

On Mon, 1 May 2006 17:36:24 -0700, "Denys" wrote:

I'm trying to have a formula to change the color of a cell when a number is
type in.

ie., 1= red; 2=yellow; 3=blue, etc.

I've been looking all over, but to no avail.

I want the cell to change color if number 1 is typed in it, etc....

any help would be appreciated it.

Thanks in advance

Denys