Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula which changes color
Hi guys, I have a list of numbers in a column as a result of a calculation from another sheet and I would like to assign a color to this number if the number is between 20-25, another color if between 15-19, etc. Is there a formula or a macro which allows me do that? Thanks! the dude -- the dude ------------------------------------------------------------------------ the dude's Profile: http://www.excelforum.com/member.php...o&userid=32838 View this thread: http://www.excelforum.com/showthread...hreadid=547375 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula which changes color
Yes. You can set-up formatting as a function of a cell's value by using
conditional formatting: 1. select a cell 2. pull-down: Format Conditional Formatting But I would look at Excel Help or: http://www.contextures.com/xlCondFormat01.html first -- Gary's Student "the dude" wrote: Hi guys, I have a list of numbers in a column as a result of a calculation from another sheet and I would like to assign a color to this number if the number is between 20-25, another color if between 15-19, etc. Is there a formula or a macro which allows me do that? Thanks! the dude -- the dude ------------------------------------------------------------------------ the dude's Profile: http://www.excelforum.com/member.php...o&userid=32838 View this thread: http://www.excelforum.com/showthread...hreadid=547375 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How would I write a max formula that included color formats? | Excel Discussion (Misc queries) | |||
hit F2, want the color coded formula to appear in formula bar not | Excel Worksheet Functions | |||
color code cells based on golddigger formula | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Portion of concatenate formula to have different color and font fo | Excel Worksheet Functions |