Conditional Formatting

[30percent]

Hi,

I have a workbook, with an api feed feeding data to it. e.g. cell A1 contain data of current weather: "81"

As the weather changes, increasing and decreasing, the number on the cell changes to denote the current weather.

Is there a way to conditional format the cell, so that if the weather increases the color of the cell is green and if the weather decreases the color of the cell is red?

Thank you!

 

[GlennUK]

You'd need to capture what the previous value was, and set a flag for the last movement ( increase or decrease ), and refer to that in your conditional formatting. The trouble is you'd need a macro to fire every so often to look at the current value ... so now your talking about having an OnTime event macro ... how do you feel about that?

How often does the data in cell A1 refresh?