Thanks for your help guys, this works a treat, I really appreciate
your replies. I was a bit stuck on that one...

Steve

On Tue, 26 Sep 2006 05:35:01 -0700, Anthony D
wrote:

ps. should have mentioned that the font colour can be set as well (or
instead) to red using the Font tab instead of (or as well as) the Patterns
tab in the Conditional Formatting.

Anthony

"Steve Squires" wrote:

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