Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 24th 04, 06:27 PM
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  
Old November 24th 04, 07:25 PM
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  
Old November 25th 04, 09:50 AM
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) 1 January 5th 05 08:36 AM
EXCEL cells colors bernard Excel Discussion (Misc queries) 1 December 19th 04 11:36 AM
linking cells in Excel 2003. How to not truncate to 255 characters. GarryFerg Excel Discussion (Misc queries) 5 December 8th 04 03:33 PM
How do I change an Excel range of cells from relative to absolute. Jrhenk Excel Worksheet Functions 2 November 15th 04 10:55 PM
stop excel from shifting cells up when a query returns no data DrLostinExcel Excel Worksheet Functions 2 November 9th 04 05:44 PM


All times are GMT +1. The time now is 08:44 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017