FormatConditional Formatting.

You can have up to 3 conditions, 4 if you count default.

For an add-in that will give you up to 30 conditions see Bob Phillips' site.

http://www.xldynamic.com/source/xld.....Download.html


Gord Dibben MS Excel MVP

On Thu, 31 Aug 2006 16:37:01 -0700, j.kuhnke
wrote:

I need to automatically fill (w/ color) cells, only if a value is entered in
it, otherwise i would like them to stay white. big time saver for the
formatting that i have to do.

aka, when i type in a number, the cell automatically colors. if the number
is 1 i need the cell to be red, if 2 i need the cell to be yellow, if 3 i
need it to be blue.