Nested loop Question ?

Posted by KTD on June 22, 2001 5:47 AM

Here is what I would "like" to do. Cell a1 would equal closing stock price, cell a2 would equal current stock price. What I would like to do is have cell a2 become bold, or another color if, and only if the value in a2 is greater than cell a1 by a certain percantage. If this is possible and you have the answer, I would much appreciate a helping hand...thank you

Posted by Dax on June 22, 2001 6:07 AM

Hi,

You could use Conditional formatting to achieve this. With cell A2 active click Format, Conditional Formatting and choose your criteria. Say you wanted the cell to be bold if the price difference was greater than 20% you'd click Greater than and then type in =A1*1.2

HTH,
Dax.

Posted by Kieran Donnelly on June 22, 2001 7:37 AM

DAN, THANK YOU VERY MUCH. Knowledge is a powerful thing.