Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL 2003*FORMULA TO HILIGHT SPECIFIC CELLS WITH TRUE RESULTS?
Hi,
Does anyone know if there is a formula I can add into a formula already written that will highlight the cells that return true results and the primary formula cell too? When the below formula, located in cell B24, returns the true value, I want it to highlight itself and each of the referenced cells causing the true value. =IF(OR(B190.5,B200.5,B210.5,B230.5),"QUOTE IN MD OVER .500""",0) Any help would be wonderful. -- Ever so greatful, tlc |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL 2003*FORMULA TO HILIGHT SPECIFIC CELLS WITH TRUE RESULTS?
Highlight cells B19:B24, click on FORMAT CONDITIONAL FORMATTING
Condition1 - FormulaIs: =$C$15="QUOTE IN MD OVER .500""" ....and then click FORMAT and setup the colors you want. Now they will all change color at the same time. Will that work for you? -- "Actually, I AM a rocket scientist." -- JB "tlc" wrote: Hi, Does anyone know if there is a formula I can add into a formula already written that will highlight the cells that return true results and the primary formula cell too? When the below formula, located in cell B24, returns the true value, I want it to highlight itself and each of the referenced cells causing the true value. =IF(OR(B190.5,B200.5,B210.5,B230.5),"QUOTE IN MD OVER .500""",0) Any help would be wonderful. -- Ever so greatful, tlc |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL 2003*FORMULA TO HILIGHT SPECIFIC CELLS WITH TRUE RESULTS
My apologies...that formula should be:
=$B$24="QUOTE IN MD OVER .500""" Is that better? -- "Actually, I AM a rocket scientist." -- JB "JBeaucaire" wrote: Highlight cells B19:B24, click on FORMAT CONDITIONAL FORMATTING Condition1 - FormulaIs: =$C$15="QUOTE IN MD OVER .500""" ...and then click FORMAT and setup the colors you want. Now they will all change color at the same time. Will that work for you? -- "Actually, I AM a rocket scientist." -- JB "tlc" wrote: Hi, Does anyone know if there is a formula I can add into a formula already written that will highlight the cells that return true results and the primary formula cell too? When the below formula, located in cell B24, returns the true value, I want it to highlight itself and each of the referenced cells causing the true value. =IF(OR(B190.5,B200.5,B210.5,B230.5),"QUOTE IN MD OVER .500""",0) Any help would be wonderful. -- Ever so greatful, tlc |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL 2003*FORMULA TO HILIGHT SPECIFIC CELLS WITH TRUE RESULTS
Thank you so much for responding JB,
I seem to be suffering an 'operator error' moment, I entered the information as you were kind enough to provide, but it isn't changing the format for some reason. I understand how it is supposed to work though (thank you for that too). Can you think of any reason it wouldn't respond correctly, like the cells are locked or hidden, or...? -- Ever so greatful, tlc "JBeaucaire" wrote: My apologies...that formula should be: =$B$24="QUOTE IN MD OVER .500""" Is that better? -- "Actually, I AM a rocket scientist." -- JB "JBeaucaire" wrote: Highlight cells B19:B24, click on FORMAT CONDITIONAL FORMATTING Condition1 - FormulaIs: =$C$15="QUOTE IN MD OVER .500""" ...and then click FORMAT and setup the colors you want. Now they will all change color at the same time. Will that work for you? -- "Actually, I AM a rocket scientist." -- JB "tlc" wrote: Hi, Does anyone know if there is a formula I can add into a formula already written that will highlight the cells that return true results and the primary formula cell too? When the below formula, located in cell B24, returns the true value, I want it to highlight itself and each of the referenced cells causing the true value. =IF(OR(B190.5,B200.5,B210.5,B230.5),"QUOTE IN MD OVER .500""",0) Any help would be wonderful. -- Ever so greatful, tlc |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL 2003*FORMULA TO HILIGHT SPECIFIC CELLS WITH TRUE RESULTS
Firstly, go back into CF and check that you've got exactly what it says
(checking the obvious things like making sure that you've used Formula Is, not Cell Value Is, and that you haven't got additional quote marks beyond what was suggested). I hope that you copied the formula from here and pasted it into the Formula Is dialogue in CF, and that you didn't try to retype it. If in doubt, copy the content of the "Formula Is" dialogue box and paste it back in here. Check also that your B24 formula is exactly as you posted in your previous message. Again, if in doubt copy B24's formula bar and paste in here so that it can be checked. Secondly, use a spare cell and put the formula =$B$24="QUOTE IN MD OVER ..500""" into the formula bar of the cell so that you can see whether it returns TRUE or FALSE. If all else fails and you still can't understand why it's not working, you could change the condition from =$B$24="QUOTE IN MD OVER .500""" to =OR(B$190.5,B$200.5,B$210.5,B$230.5) This ought to give exactly the same result, but is an alternative to try if you are totally stuck. -- David Biddulph "tlc" wrote in message ... Thank you so much for responding JB, I seem to be suffering an 'operator error' moment, I entered the information as you were kind enough to provide, but it isn't changing the format for some reason. I understand how it is supposed to work though (thank you for that too). Can you think of any reason it wouldn't respond correctly, like the cells are locked or hidden, or...? -- Ever so greatful, tlc "JBeaucaire" wrote: My apologies...that formula should be: =$B$24="QUOTE IN MD OVER .500""" Is that better? -- "Actually, I AM a rocket scientist." -- JB "JBeaucaire" wrote: Highlight cells B19:B24, click on FORMAT CONDITIONAL FORMATTING Condition1 - FormulaIs: =$C$15="QUOTE IN MD OVER .500""" ...and then click FORMAT and setup the colors you want. Now they will all change color at the same time. Will that work for you? -- "Actually, I AM a rocket scientist." -- JB "tlc" wrote: Hi, Does anyone know if there is a formula I can add into a formula already written that will highlight the cells that return true results and the primary formula cell too? When the below formula, located in cell B24, returns the true value, I want it to highlight itself and each of the referenced cells causing the true value. =IF(OR(B190.5,B200.5,B210.5,B230.5),"QUOTE IN MD OVER .500""",0) Any help would be wonderful. -- Ever so greatful, tlc |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL 2003*FORMULA TO HILIGHT SPECIFIC CELLS WITH TRUE RESULTS
Dear David and JB,
Great help from you both. I finally overcame my 'operator error'. I realized the cell B24 was merged with A24 and C24 making the correct entry =$A$24=.... I also discovered that both versions formatted every one of the cells B19 - B23 if the condition appeared in just one. Thanks to your help and insight, I figured out I needed to conditional format each cell individually to change only the cell with the over .5 entry and cf cell A24 "Quote in...." to even better results than I had hoped Now it works to perfection! Thank you both so very much. Your help is so very much appreciated. :-) -- Ever so greatful, tlc "David Biddulph" wrote: Firstly, go back into CF and check that you've got exactly what it says (checking the obvious things like making sure that you've used Formula Is, not Cell Value Is, and that you haven't got additional quote marks beyond what was suggested). I hope that you copied the formula from here and pasted it into the Formula Is dialogue in CF, and that you didn't try to retype it. If in doubt, copy the content of the "Formula Is" dialogue box and paste it back in here. Check also that your B24 formula is exactly as you posted in your previous message. Again, if in doubt copy B24's formula bar and paste in here so that it can be checked. Secondly, use a spare cell and put the formula =$B$24="QUOTE IN MD OVER ..500""" into the formula bar of the cell so that you can see whether it returns TRUE or FALSE. If all else fails and you still can't understand why it's not working, you could change the condition from =$B$24="QUOTE IN MD OVER .500""" to =OR(B$190.5,B$200.5,B$210.5,B$230.5) This ought to give exactly the same result, but is an alternative to try if you are totally stuck. -- David Biddulph "tlc" wrote in message ... Thank you so much for responding JB, I seem to be suffering an 'operator error' moment, I entered the information as you were kind enough to provide, but it isn't changing the format for some reason. I understand how it is supposed to work though (thank you for that too). Can you think of any reason it wouldn't respond correctly, like the cells are locked or hidden, or...? -- Ever so greatful, tlc "JBeaucaire" wrote: My apologies...that formula should be: =$B$24="QUOTE IN MD OVER .500""" Is that better? -- "Actually, I AM a rocket scientist." -- JB "JBeaucaire" wrote: Highlight cells B19:B24, click on FORMAT CONDITIONAL FORMATTING Condition1 - FormulaIs: =$C$15="QUOTE IN MD OVER .500""" ...and then click FORMAT and setup the colors you want. Now they will all change color at the same time. Will that work for you? -- "Actually, I AM a rocket scientist." -- JB "tlc" wrote: Hi, Does anyone know if there is a formula I can add into a formula already written that will highlight the cells that return true results and the primary formula cell too? When the below formula, located in cell B24, returns the true value, I want it to highlight itself and each of the referenced cells causing the true value. =IF(OR(B190.5,B200.5,B210.5,B230.5),"QUOTE IN MD OVER .500""",0) Any help would be wonderful. -- Ever so greatful, tlc |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL 2003*FORMULA TO HILIGHT SPECIFIC CELLS WITH TRUE RESULTS
I *hope* you didn't manually type in all those CF cells. You don't have to do
that. You just need to highlight all the cells that will use this CF, open the CF window and enter the formula but remove the $ flags, so $B$24 (absolute reference) becomes just B24 (relative reference). Now Excel will adjust the reference for each of the cells highlighted FOR you. -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "tlc" wrote: Dear David and JB, Great help from you both. I finally overcame my 'operator error'. I realized the cell B24 was merged with A24 and C24 making the correct entry =$A$24=.... I also discovered that both versions formatted every one of the cells B19 - B23 if the condition appeared in just one. Thanks to your help and insight, I figured out I needed to conditional format each cell individually to change only the cell with the over .5 entry and cf cell A24 "Quote in...." to even better results than I had hoped Now it works to perfection! Thank you both so very much. Your help is so very much appreciated. :-) -- Ever so greatful, tlc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide data in specific rows/colums/cells in Excel 2003 | Excel Discussion (Misc queries) | |||
Return Formula results to specific row of matched criteria | Excel Worksheet Functions | |||
Excel 2003 :Summing specific cells of a particular color in a colu | Excel Discussion (Misc queries) | |||
View formula results instead of formula in 2003 version? | Excel Discussion (Misc queries) | |||
How do I have a IF AND formula read 2 different cells to be true | Excel Worksheet Functions |