Changing cell color

I need to either write a macro or a formula that will automatically change
the font of a cell if it is greater than the previous cell. For example, if
a1 = 3 and b1 = 4, I need 4 to be a different color. Can this be done? Any
help would be greatly appreciated.

Hi Kas

You van use CF
http://www.contextures.com/xlCondFormat01.html

Select b1:Z1 ?

And use this formula
=A1<B1

Choose the format you want

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kas" <[email protected]> wrote in message news:[email protected]...
>I need to either write a macro or a formula that will automatically change
> the font of a cell if it is greater than the previous cell. For example, if
> a1 = 3 and b1 = 4, I need 4 to be a different color. Can this be done? Any
> help would be greatly appreciated.

The help for "conditional formatting" will tell you how to do it.

Wolf

"Kas" wrote:

> I need to either write a macro or a formula that will automatically change
> the font of a cell if it is greater than the previous cell. For example, if
> a1 = 3 and b1 = 4, I need 4 to be a different color. Can this be done? Any
> help would be greatly appreciated.