| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Cell Color
Hello.
I I keep track of my bowling teams statistics. I type the scores in columns C thru E rows 3 to 34. I have the formula for average in column H3 thru H34. When I type the scores in, I would like the color of the text to be red for scores under average, black for scores from the average to 199, and green from 200 and above. Is there anyway to do this automatically? I am a new user. Thank you very much. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Cell Color
Take a look at Conditional Formatting on the Format menu.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Chuckers" wrote in message ... Hello. I I keep track of my bowling teams statistics. I type the scores in columns C thru E rows 3 to 34. I have the formula for average in column H3 thru H34. When I type the scores in, I would like the color of the text to be red for scores under average, black for scores from the average to 199, and green from 200 and above. Is there anyway to do this automatically? I am a new user. Thank you very much. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Cell Color
Yes, I looked at that and tried a few things but couldn't figure out the
formula. Is there a place to learn about this? Thank you. "Chip Pearson" wrote: Take a look at Conditional Formatting on the Format menu. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Chuckers" wrote in message ... Hello. I I keep track of my bowling teams statistics. I type the scores in columns C thru E rows 3 to 34. I have the formula for average in column H3 thru H34. When I type the scores in, I would like the color of the text to be red for scores under average, black for scores from the average to 199, and green from 200 and above. Is there anyway to do this automatically? I am a new user. Thank you very much. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Cell Color
You could start with Excel's Help
or Debra Dalgleish's site: http://www.contextures.com/xlCondFormat01.html Chuckers wrote: Yes, I looked at that and tried a few things but couldn't figure out the formula. Is there a place to learn about this? Thank you. "Chip Pearson" wrote: Take a look at Conditional Formatting on the Format menu. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Chuckers" wrote in message ... Hello. I I keep track of my bowling teams statistics. I type the scores in columns C thru E rows 3 to 34. I have the formula for average in column H3 thru H34. When I type the scores in, I would like the color of the text to be red for scores under average, black for scores from the average to 199, and green from 200 and above. Is there anyway to do this automatically? I am a new user. Thank you very much. -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Cell Color
Thanks very much. I think I've got it. I was able to do it for one row at a
time. I couldn't figure out how to all rows at the same time. "Dave Peterson" wrote: You could start with Excel's Help or Debra Dalgleish's site: http://www.contextures.com/xlCondFormat01.html Chuckers wrote: Yes, I looked at that and tried a few things but couldn't figure out the formula. Is there a place to learn about this? Thank you. "Chip Pearson" wrote: Take a look at Conditional Formatting on the Format menu. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Chuckers" wrote in message ... Hello. I I keep track of my bowling teams statistics. I type the scores in columns C thru E rows 3 to 34. I have the formula for average in column H3 thru H34. When I type the scores in, I would like the color of the text to be red for scores under average, black for scores from the average to 199, and green from 200 and above. Is there anyway to do this automatically? I am a new user. Thank you very much. -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Cell Color
If you select the whole range, you can write your format|conditional formatting
formula based on the activecell. Excel will adjust the range--just like it does when you copy a formula down a column. If you select A1:Z99 (say) and use this as your conditional formatting formula: =$a16 It'll adjust the row for each row in that range (and won't adjust the column). Chuckers wrote: Thanks very much. I think I've got it. I was able to do it for one row at a time. I couldn't figure out how to all rows at the same time. "Dave Peterson" wrote: You could start with Excel's Help or Debra Dalgleish's site: http://www.contextures.com/xlCondFormat01.html Chuckers wrote: Yes, I looked at that and tried a few things but couldn't figure out the formula. Is there a place to learn about this? Thank you. "Chip Pearson" wrote: Take a look at Conditional Formatting on the Format menu. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Chuckers" wrote in message ... Hello. I I keep track of my bowling teams statistics. I type the scores in columns C thru E rows 3 to 34. I have the formula for average in column H3 thru H34. When I type the scores in, I would like the color of the text to be red for scores under average, black for scores from the average to 199, and green from 200 and above. Is there anyway to do this automatically? I am a new user. Thank you very much. -- Dave Peterson -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Cell Color
Thank you, Thank you, thank you.
I selected cells C4 thru E34, I used condition 1, cell value is-greater than-199,format green condition 2, formula is C4<H3,format red anything else is black. worked like a charm. "Dave Peterson" wrote: If you select the whole range, you can write your format|conditional formatting formula based on the activecell. Excel will adjust the range--just like it does when you copy a formula down a column. If you select A1:Z99 (say) and use this as your conditional formatting formula: =$a16 It'll adjust the row for each row in that range (and won't adjust the column). Chuckers wrote: Thanks very much. I think I've got it. I was able to do it for one row at a time. I couldn't figure out how to all rows at the same time. "Dave Peterson" wrote: You could start with Excel's Help or Debra Dalgleish's site: http://www.contextures.com/xlCondFormat01.html Chuckers wrote: Yes, I looked at that and tried a few things but couldn't figure out the formula. Is there a place to learn about this? Thank you. "Chip Pearson" wrote: Take a look at Conditional Formatting on the Format menu. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Chuckers" wrote in message ... Hello. I I keep track of my bowling teams statistics. I type the scores in columns C thru E rows 3 to 34. I have the formula for average in column H3 thru H34. When I type the scores in, I would like the color of the text to be red for scores under average, black for scores from the average to 199, and green from 200 and above. Is there anyway to do this automatically? I am a new user. Thank you very much. -- Dave Peterson -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Cell Color
Yes but it would be better to select the cells that you want to be affected first
i.e. entire columns, rather than coping formatting afterwards. http://www.mvps.org/dmcritchie/excel/condfmt.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Chuckers" wrote in message ... Thank you, Thank you, thank you. I selected cells C4 thru E34, I used condition 1, cell value is-greater than-199,format green condition 2, formula is C4<H3,format red anything else is black. worked like a charm. |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Cell Color
Yes, I played around with it some more and what I ended up doing is selecting
all the cells and for condition 1: Formula is - =C3<ROUNDDOWN($H2,0) - format red and condition 2: Cell Value is - = 200 - format green. Thank you very much for the reply. "David McRitchie" wrote: Yes but it would be better to select the cells that you want to be affected first i.e. entire columns, rather than coping formatting afterwards. http://www.mvps.org/dmcritchie/excel/condfmt.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Chuckers" wrote in message ... Thank you, Thank you, thank you. I selected cells C4 thru E34, I used condition 1, cell value is-greater than-199,format green condition 2, formula is C4<H3,format red anything else is black. worked like a charm. |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Cell Color
and that was with C3 as your active cell when you entered the formula, right,
because the active cell is the key to formula usage. "Chuckers" wrote Yes, I played around with it some more and what I ended up doing is selecting all the cells and for condition 1: Formula is - =C3<ROUNDDOWN($H2,0) - format red and condition 2: Cell Value is - = 200 - format green. Thank you very much for the reply. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Transfer cell color | Excel Worksheet Functions | |||
| SQL - Auto Refresh Upon Cell Value Change | Excel Worksheet Functions | |||
| Change cell color dependin on date ... | Excel Worksheet Functions | |||
| Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
Linear Mode
