Hi there,
I have a lot of live streaming figures (Foreign Exchange rates) in my spreadsheets and I want to find out how:
Let's say, I have one variable figure and one static figure. The live figure is 1.2800 and the static figure is 1.2780.
If the live figure drops below the static figure I want to be able to colour the entire row red BUT if the live figure shoots back up over the static figure I still want the row to remain red - sounds like a binary problem.
Please let me know if you can help.
Thanks.
Bookmarks