cell formating based on value

C

Carl Hilton

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

Thanks
Carl
 
C

Carl Hilton

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
 
B

Bob Phillips

Both were available in XL97 Carl.

Bob


Carl Hilton said:
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
Click to expand...
 
G

Gord Dibben

Carl

VLOOKUP has been around for many versions.

Conditional Formatting was introduced in Excel 97


Gord Dibben Excel MVP
 
Top