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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Newbie Help - IF Yes No Function 0
Fill tringle in a cell with color 1
Match table shading (color) to Visio color/Transparency 1
shading a cell or group of cells based on value 5
Paste to excel from word - auto format problem 1
Need Help with a VBA subroutine 0
Excel 2010 Conditional Formatting 2

Top