Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default how can i change the colour of eg. datas more than 10%?

Dear all,
i want to show some cells in another colour ( eg. numbers more than 10% in
red).how can i do this?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,124
Default how can i change the colour of eg. datas more than 10%?

have a look at formattingconditional formatting


--
Don Guillett
SalesAid Software

"Nazli" wrote in message
...
Dear all,
i want to show some cells in another colour ( eg. numbers more than 10% in
red).how can i do this?



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default how can i change the colour of eg. datas more than 10%?

FormatConditional Formatting


Gord Dibben MS Excel MVP

On Sun, 23 Jul 2006 05:29:01 -0700, Nazli
wrote:

Dear all,
i want to show some cells in another colour ( eg. numbers more than 10% in
red).how can i do this?


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
how you change font colour in header/footer? Jo Lant Excel Discussion (Misc queries) 1 June 26th 06 12:40 PM
change a cell background colour to my own RGB colour requirements Stephen Doughty Excel Discussion (Misc queries) 4 June 16th 06 01:08 PM
Columns change colour with value koootzz Charts and Charting in Excel 1 January 30th 06 08:09 PM
How do I get traffic lights in excel that change colour Shorty Excel Worksheet Functions 2 December 23rd 04 01:24 AM
Macro button colour change??? Beefyme Excel Worksheet Functions 1 November 19th 04 06:15 PM


All times are GMT +1. The time now is 03:36 PM.

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

About Us

"It's about Microsoft Excel"