| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Color Formatting
Two Questioins
1. What is the formula to use when you need cells in a column to switch text colors if it is under a certain percentage. i.e. column "o" under 95% 2. Formula to change cell color of adjacents cells to yellow if between 0:06-0:10 seconds, red if over 0:11 seconds? ie. column c 0:07 seconds, columns a-e = yellow. thank you!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Color Formatting
Not a formula in the cell but Conditional Formatting will do this very well.
Look it up in 'Help' Regards, Alan. "Todd Nelson" wrote in message ... Two Questioins 1. What is the formula to use when you need cells in a column to switch text colors if it is under a certain percentage. i.e. column "o" under 95% 2. Formula to change cell color of adjacents cells to yellow if between 0:06-0:10 seconds, red if over 0:11 seconds? ie. column c 0:07 seconds, columns a-e = yellow. thank you!!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Color Formatting
Hi Todd You can't change formatting with formula. But you can use Conditional Formatting (Format---Conditional Formatting). There you can control the format of a range (or individual cell) according to its value or by means of a formula. You can use, of course, Vba. -- jordun ------------------------------------------------------------------------ jordun's Profile: http://www.excelforum.com/member.php...o&userid=33118 View this thread: http://www.excelforum.com/showthread...hreadid=529349 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Color Formatting
When I use the conditional formatting I am not able to find where I can color
adjacent cells as well, I can only color the one cell in reference "jordun" wrote: Hi Todd You can't change formatting with formula. But you can use Conditional Formatting (Format---Conditional Formatting). There you can control the format of a range (or individual cell) according to its value or by means of a formula. You can use, of course, Vba. -- jordun ------------------------------------------------------------------------ jordun's Profile: http://www.excelforum.com/member.php...o&userid=33118 View this thread: http://www.excelforum.com/showthread...hreadid=529349 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Color Formatting
See http://www.mvps.org/dmcritchie/excel/excel.htm
which cells get colored depend on which cells/columns are selected based on you formula which is adjusted for each cell based on the active cell. So your formula would use $ in front of the column letter to show /that/ that column is the one to be tested. --- 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 "Todd Nelson" wrote in message ... When I use the conditional formatting I am not able to find where I can color adjacent cells as well, I can only color the one cell in reference "jordun" wrote: Hi Todd You can't change formatting with formula. But you can use Conditional Formatting (Format---Conditional Formatting). There you can control the format of a range (or individual cell) according to its value or by means of a formula. You can use, of course, Vba. -- jordun ------------------------------------------------------------------------ jordun's Profile: http://www.excelforum.com/member.php...o&userid=33118 View this thread: http://www.excelforum.com/showthread...hreadid=529349 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Color Formatting
You select the adjacent cell and apply the same condition to it, referencing
the other cell. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Todd Nelson" wrote in message ... When I use the conditional formatting I am not able to find where I can color adjacent cells as well, I can only color the one cell in reference "jordun" wrote: Hi Todd You can't change formatting with formula. But you can use Conditional Formatting (Format---Conditional Formatting). There you can control the format of a range (or individual cell) according to its value or by means of a formula. You can use, of course, Vba. -- jordun ------------------------------------------------------------------------ jordun's Profile: http://www.excelforum.com/member.php...o&userid=33118 View this thread: http://www.excelforum.com/showthread...hreadid=529349 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Color Formatting
Correction, see
Conditional Formatting http://www.mvps.org/dmcritchie/excel/condfmt.htm If you do it as I mentioned you only have to apply the formula once no copying. "David McRitchie" wrote in message ... See http://www.mvps.org/dmcritchie/excel/excel.htm which cells get colored depend on which cells/columns are selected based on you formula which is adjusted for each cell based on the active cell. So your formula would use $ in front of the column letter to show /that/ that column is the one to be tested. --- 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 "Todd Nelson" wrote in message ... When I use the conditional formatting I am not able to find where I can color adjacent cells as well, I can only color the one cell in reference "jordun" wrote: Hi Todd You can't change formatting with formula. But you can use Conditional Formatting (Format---Conditional Formatting). There you can control the format of a range (or individual cell) according to its value or by means of a formula. You can use, of course, Vba. -- jordun ------------------------------------------------------------------------ jordun's Profile: http://www.excelforum.com/member.php...o&userid=33118 View this thread: http://www.excelforum.com/showthread...hreadid=529349 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Color Formatting
Ok, I am thoroughly confused by this. When using the format painter it is
encountering a problem because the cell values are different. I have a time span in the 1st column, a number value in the 2nd and time in seconds in the third. The painter automatically changes the cell format. "Todd Nelson" wrote: Two Questioins 1. What is the formula to use when you need cells in a column to switch text colors if it is under a certain percentage. i.e. column "o" under 95% 2. Formula to change cell color of adjacents cells to yellow if between 0:06-0:10 seconds, red if over 0:11 seconds? ie. column c 0:07 seconds, columns a-e = yellow. thank you!!! |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Color Formatting
wow, this was a lot easier than I made it, thank you to everyone for helping
stupid me get this one figured out! "Bob Phillips" wrote: You select the adjacent cell and apply the same condition to it, referencing the other cell. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Todd Nelson" wrote in message ... When I use the conditional formatting I am not able to find where I can color adjacent cells as well, I can only color the one cell in reference "jordun" wrote: Hi Todd You can't change formatting with formula. But you can use Conditional Formatting (Format---Conditional Formatting). There you can control the format of a range (or individual cell) according to its value or by means of a formula. You can use, of course, Vba. -- jordun ------------------------------------------------------------------------ jordun's Profile: http://www.excelforum.com/member.php...o&userid=33118 View this thread: http://www.excelforum.com/showthread...hreadid=529349 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
