Ok, you have a few conditions:

Isblank(d1) means clear
Formatted as Currency Means €œBlue€�
Any value not formatted as Currency Means Red

Step 1
I would insert a column to calculate this and format based on the results of
the formula:
=IF(ISBLANK(D1),"clear",IF(AND(CELL("format",D1)= "C",CELL("format",D1)<="C2"),"blue",IF(D1=0,"Blue" ,"Red")))

Then Step two, Use conditional Formatting. You would need to set 3
conditions (leaving the result of clear to do nothing).
Assuming you insert the above formula into column E the First formula in
conditional formatting would look like this:
=$E1="Red"

Set the result of the condition to a Red fill color.

Note: Make sure to remove the €œ$€� in front of the 1 otherwise it will not
work if these conditions are applisd to more than one row.

Just do the same for €œBlue€�
=$E1="Blue"

Hope that helps!

Frank


"Brian" wrote:

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