Hi guys, hope you can help
I got a strange request, is it possible to change the color of a value
in an input cell after a value has been entered, based on a simple
subtraction formula?
Let me make that clearer, If I had two columns a1 and b1, and I type a
value of 18 into cell a1, then a value of 10 into cell b1, is it
possible to change the color of the value in cell b1 to red
"on-the-fly", based on the fact that it is a smaller value than a1?
(If the value of b1 was to be 19 then the color would remain black,
because it is greater than 18)
If not, is it possible to create a macro or script button that I can
press afterwards to calculate and change the color for me?
Thanks guys
Steve