Macro for cell colors?
Hello all,
I don't know if this can be done or how it would be done, so I am asking the experts. Here is my questions. I have a row with targets and 4 rows of with test results. If the test is out of tolorance the cell will be yellow. If the test is out by alot (6%) then the cell turns red. If it is a good test the cell is white. I figured this out in conditional formatting. Here is my main question..... Is there a way to have a macro determine what color the cell is and tell me what status we are at. For instance, if the cell is white "continue", if the cell is yellow "continue", if cell is red "Stop". example: A B C D Targets~~ 5 6 7 8 1 5 5 7 4~~this would be red we must "stop". Columns A,B,C are white 2 5 5 7 5~~ this would be yellow "continue" with testing. ABC are white 3 5 5 7 5~~ this would be yellow stop because you have 2 yellows in a row 4 5 6 7 8~~ everything is white so we can continue with testing Eric |
Macro for cell colors?
On Apr 10, 8:23*am, Eric wrote:
Hello all, I don't know if this can be done or how it would be done, so I am asking the experts. *Here is my questions. I have a row with targets and 4 rows of with test results. *If the test is out of tolorance the cell will be yellow. *If the test is out by alot (6%) then the cell turns red. *If it is a good test the cell is white. *I figured this out in conditional formatting. *Here is my main question..... Is there a way to have a macro determine what color the cell is and tell me what status we are at. *For instance, if the cell is white "continue", if the cell is yellow "continue", if cell is red "Stop". example: * * * * * * * * * * * *A * * * * * B * * * * * * C * * * * * * D Targets~~ * * 5 * * * * * 6 * * * * * * *7 * * * * * * 8 1 * * * * * * * * * * 5 * * * * * 5 * * * * * * *7 * * * * * * 4~~this would be red we must "stop". *Columns A,B,C are white 2 * * * * * * * * * * 5 * * * * * 5 * * * * * * *7 * * * * * * 5~~ this would be yellow "continue" with testing. *ABC are white 3 * * * * * * * * * * 5 * * * * * 5 * * * * * * *7 * * * * * * 5~~ this would be yellow stop because you have 2 yellows in a row 4 * * * * * * * * * *5 * * * * * 6 * * * * * * *7 * * * * * * 8~~ * everything is white so we can continue with testing Eric I've done the same ... but without conditional formatting, just with highlighting via code. If you do it that way, you have a much easier time adding "status" etc. Cheers, HTH Chris |
Macro for cell colors?
Chip Pearson has some code that might lead you in the right direction...
http://www.cpearson.com/excel/colors.aspx Mark Ivey "Eric" wrote in message ... Hello all, I don't know if this can be done or how it would be done, so I am asking the experts. Here is my questions. I have a row with targets and 4 rows of with test results. If the test is out of tolorance the cell will be yellow. If the test is out by alot (6%) then the cell turns red. If it is a good test the cell is white. I figured this out in conditional formatting. Here is my main question..... Is there a way to have a macro determine what color the cell is and tell me what status we are at. For instance, if the cell is white "continue", if the cell is yellow "continue", if cell is red "Stop". example: A B C D Targets~~ 5 6 7 8 1 5 5 7 4~~this would be red we must "stop". Columns A,B,C are white 2 5 5 7 5~~ this would be yellow "continue" with testing. ABC are white 3 5 5 7 5~~ this would be yellow stop because you have 2 yellows in a row 4 5 6 7 8~~ everything is white so we can continue with testing Eric |
All times are GMT +1. The time now is 02:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com