cell formating based on value

  • Thread starter Thread starter Carl Hilton
  • Start date Start date
C

Carl Hilton

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
 
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...
 
Carl

VLOOKUP has been around for many versions.

Conditional Formatting was introduced in Excel 97


Gord Dibben Excel MVP
 
You must log in or register to reply here.

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 VBA 1
shading a cell or group of cells based on value 5
Excel VBA to move cells to sheet2 based on selection in sheet1 0
conditonal format A2 using value in another cell C2 1
Excel Macro to automatically go to the right of the last colored cell 0
Conditional format a column based on value in a different column 3
Conditional Format Won't Update Cell 8
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Back
Top