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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> 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" <[email protected]> wrote in message
>news:[email protected]...
>> How can I format a cell (specifically cell color) based on the value of
>the
>> cell?
>>
>> Thanks
>> Carl
>>
>>
>