Thread: cell formating based on value

How can I format a cell (specifically cell color) based on the value of the
cell?

Thanks
Carl

OK, I found the conditional formatting... My question is now..

When was the function VLOOKUP added to excel? and when we the CONDITIONAL
FORMATTING added to excel? I am create a spread sheet for my wife's school
class, and although we have O2K3 at home, other teachers at her school have
various version from O97 throug OXP.

Carl
"Carl Hilton" <noone@nospam.com> wrote in message
news:ehF$eUn9EHA.1084@TK2MSFTNGP15.phx.gbl...
> How can I format a cell (specifically cell color) based on the value of
the
> cell?
>
> Thanks
> Carl
>
>

Both were available in XL97 Carl.

Bob


"Carl Hilton" <noone@nospam.com> wrote in message
news:OXAbsYn9EHA.2788@TK2MSFTNGP10.phx.gbl...
> OK, I found the conditional formatting... My question is now..
>
> When was the function VLOOKUP added to excel? and when we the CONDITIONAL
> FORMATTING added to excel? I am create a spread sheet for my wife's school
> class, and although we have O2K3 at home, other teachers at her school
have
> various version from O97 throug OXP.
>
> Carl
> "Carl Hilton" <noone@nospam.com> wrote in message
> news:ehF$eUn9EHA.1084@TK2MSFTNGP15.phx.gbl...
> > How can I format a cell (specifically cell color) based on the value of
> the
> > cell?
> >
> > Thanks
> > Carl
> >
> >
>
>

Carl

VLOOKUP has been around for many versions.

Conditional Formatting was introduced in Excel 97


Gord Dibben Excel MVP

\On Sun, 9 Jan 2005 13:08:05 -0500, "Carl Hilton" <noone@nospam.com> wrote:

>OK, I found the conditional formatting... My question is now..
>
>When was the function VLOOKUP added to excel? and when we the CONDITIONAL
>FORMATTING added to excel? I am create a spread sheet for my wife's school
>class, and although we have O2K3 at home, other teachers at her school have
>various version from O97 throug OXP.
>
>Carl
>"Carl Hilton" <noone@nospam.com> wrote in message
>news:ehF$eUn9EHA.1084@TK2MSFTNGP15.phx.gbl...
>> How can I format a cell (specifically cell color) based on the value of
>the
>> cell?
>>
>> Thanks
>> Carl
>>
>>
>