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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" 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" wrote in message
...
How can I format a cell (specifically cell color) based on the value of
the
cell?

Thanks
Carl