Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
KV
 
Posts: n/a
Default How to get excel cells to change colors depending on value

I'd like to know if anyone knows how to get excel cells to change color
depending on their value. We're working with a database and want cells to
turn one color when the value is positive and another color when the value is
negative.

Thanks for the help,
KV
  #2   Report Post  
peter
 
Posts: n/a
Default

Hi,
highlight the cell and click format|conditional formating

peter
-----Original Message-----
I'd like to know if anyone knows how to get excel cells

to change color
depending on their value. We're working with a database

and want cells to
turn one color when the value is positive and another

color when the value is
negative.

Thanks for the help,
KV
.

  #3   Report Post  
Jamie Collins
 
Posts: n/a
Default

"peter" wrote ...

cells to
turn one color when the value is positive and another
color when the value is
negative.


highlight the cell and click format|conditional formating


Also, can use the older style custom number formats e.g.

[Blue]General;[Red]-General;[White]General

Anyone know where that KB article with details on these formats or has
a copy somewhere?

Jamie.

--
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
EXCEL cells colors bernard Excel Discussion (Misc queries) 1 December 19th 04 12:36 PM
linking cells in Excel 2003. How to not truncate to 255 characters. GarryFerg Excel Discussion (Misc queries) 5 December 8th 04 04:33 PM
How do I change an Excel range of cells from relative to absolute. Jrhenk Excel Worksheet Functions 2 November 15th 04 11:55 PM
stop excel from shifting cells up when a query returns no data DrLostinExcel Excel Worksheet Functions 2 November 9th 04 06:44 PM


All times are GMT +1. The time now is 11:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"