Excel 2002
I have a couple of cells with conditional formatting set to change the font color to red if the cell value is less than another cell. I am using the conditional formatting option from the format toolbar. Slect cell, click conditional formatting and enter the following:
Condition 1 : less than : ="c19"
Seems simple but it's not working. Sometimes the cells value is red when it is greater than cell c19. I've tried unlocking these cells just to see if that made a diference but to no avail. Also, these cells are stock quotes updated with a click of the Update Quotes add-in. Any ideas? Can't seem to find another instance of this. thanks
I have a couple of cells with conditional formatting set to change the font color to red if the cell value is less than another cell. I am using the conditional formatting option from the format toolbar. Slect cell, click conditional formatting and enter the following:
Condition 1 : less than : ="c19"
Seems simple but it's not working. Sometimes the cells value is red when it is greater than cell c19. I've tried unlocking these cells just to see if that made a diference but to no avail. Also, these cells are stock quotes updated with a click of the Update Quotes add-in. Any ideas? Can't seem to find another instance of this. thanks