Disable automatic cell conditional formatting

[chandler]

Disable automatic cell conditional formatting

I have an Excel Worksheet that uses a live DDE feed of the current prices of currencies. I have multiple cells with conditional formatting that show specific price levels in a different color when the live price is near that level.

However, because the live price is constantly changing, it "locks" up Excel while all of these price levels evaluate the condition.

Is there a way to retain the conditional formatting, but only have the cells check the condition either in timed intervals or manual execution?

My other question is whether my condition is too complicated? It basically checks to see if a cell value is between two numbers. =AND($T$4>VALUE(Q27),$U$4

I use value because the price levels are converted to text for number formatting based on whether the currency tracked is x.xxxx or xx.xx.

I have yet to figure out how to do conditional number formatting, hence the conversion to text.

Thanks for any help.

Chandler
I ran over my dogma with karma!

 

[SkipVought]

Hi,

How many cells are conditionally formatted: formatted range?

What is the CF formula? Your posting was truncated
[tt]
=AND($T$4>VALUE(Q27),$U$4??????????)
[/tt]


Skip,

_{[red]Be advised:[/red]We know Newton's 3 Laws. But did you hear about the [red]FOURTH???[/red]
Only ONE fig per cookie!}