LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default How do i format cell to change colour as the number increases

I want to format a cell to change colours as the total numbers increases from
10 to 20 and 30-100 with red, yellow and blue respectively in Ms excel? Also
if i input a name on a cell, Iwant the cell to format it to indicate if it
has appeared within last six months by indicating red or yellow for less than
six month or more than six month respectively?
 
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
Conditionl format a cell to change text colour PAULANDBEX24 Excel Discussion (Misc queries) 7 October 7th 08 09:05 AM
Change the colour of numbers in a cell if the number is negative bryno Excel Worksheet Functions 3 March 5th 08 09:27 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
Change cell Colour when a number of days have been passed SR7133 Excel Discussion (Misc queries) 4 March 1st 06 10:49 PM
Change colour of Text if number in cell exceed limit Lewis Koh Excel Worksheet Functions 2 August 2nd 05 02:16 AM


All times are GMT +1. The time now is 05:04 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"