Hi,

If D1 is empty then G1 should be white(clear)
if D1 has a number in it then G1 should be red
additionally;
if a value, either a figure 0 or a currency value is entered in G1, which
owing to the previous two conditions, would be red, then G1 should change to
blue.

If anyone can explain how to acheive this I would be extremely grateful.

Thank You

Brian