| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell color
I have 3 columns of cells that have numbers between 1-100 (these are percentiles). I need all cells 1-25 to be colored blue, 26-75 colored yellow, and 76-100 colored red. Is there a way I can make these cells automatically change color, or is this possible to do with a macro? Thanks Karl -- flyingmeatball ------------------------------------------------------------------------ flyingmeatball's Profile: http://www.excelforum.com/member.php...o&userid=37302 View this thread: http://www.excelforum.com/showthread...hreadid=570812 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell color
You can do this with Conditional Formatting. Select your range of cells. Go to Format. Select Conditional Format. You can then enter the conditions under which a cell would turn which color. -- jonhunt ------------------------------------------------------------------------ jonhunt's Profile: http://www.excelforum.com/member.php...o&userid=35370 View this thread: http://www.excelforum.com/showthread...hreadid=570812 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell color
Once you put in the conditions, click on format and you can select the color. Then you can set a second or third condition and select different colors for different variables. -- jonhunt ------------------------------------------------------------------------ jonhunt's Profile: http://www.excelforum.com/member.php...o&userid=35370 View this thread: http://www.excelforum.com/showthread...hreadid=570812 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell color
Use Conditional Formatting with conditions of less than 26 blue, less than
76 yellow, and less than equal 100 to red. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "flyingmeatball" <flyingmeatball.2cdtg4_1155310211.6779@excelforu m-nospam.com wrote in message news:flyingmeatball.2cdtg4_1155310211.6779@excelfo rum-nospam.com... I have 3 columns of cells that have numbers between 1-100 (these are percentiles). I need all cells 1-25 to be colored blue, 26-75 colored yellow, and 76-100 colored red. Is there a way I can make these cells automatically change color, or is this possible to do with a macro? Thanks Karl -- flyingmeatball ------------------------------------------------------------------------ flyingmeatball's Profile: http://www.excelforum.com/member.php...o&userid=37302 View this thread: http://www.excelforum.com/showthread...hreadid=570812 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro To Change Cell Color When Value Changes | Excel Worksheet Functions | |||
| cell color index comparison | New Users to Excel | |||
| Cell Change Color - Need Help | New Users to Excel | |||
| Color a cell and a value is automatically assigned to that color. | Excel Worksheet Functions | |||
| Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
Linear Mode
