Changing the color of cells by formula
 

I wish to change the colors of cells relative to values in other cells in the
same row. This is to be done automatically by formula. Can this be done?

Changing the color of cells by formula
 

You will have to use Conditional formatting (on the Format menu) with
the Formula Is option rather than Cell Contents Is. In XL 2003 and
earlier you are limited to 3 conditional formats per cell.

Hope this helps.

Pete

On Aug 24, 12:19 am, "Emerogork" <u36894@uwe wrote:
I wish to change the colors of cells relative to values in other cells in the
same row. This is to be done automatically by formula. Can this be done?