Maths to text dilema

[ukphoenix]

I know some basic formulas and conditional formatting but cant work out how to do what i need

I have 2 numbers in cells A1 and B1 returning an answer in C1 (like i said basic)
if C1 = 0 in D1 i need it to reply Full (in a GREEN cell) or
if C1 = (any number) in D1 i need it to reply DEPOSIT (in a BLUE cell) or
if C1 = A1 in D1 i need it to reply OUTSTANDING (in a RED cell)

Any help would be appreciated

[Fotis1991]

Hi

Which formula, are you using in C1?

[ukphoenix]

The basic of =sum(a1-b1)

[Fotis1991]

Is this what are you looking for?

=IF(C1=0;"Full";IF(C1<>0;"DEPOSIT";IF(AND(A1<>0;C1=A1);"OUTSTANDING";"")))

[rounakbhasin]

Along with the formula mentioned for coloring the cells follow the below steps

Select Column D
go to conditional formatting->new rule->use a formula to determine which cells to format
put $c1=0 in the formula choose the desired color.
Similarly you can put the other two conditions.

[jraj1106]

Hi

You can try this too:

TESTFILE.xlsm

Regards..

[ukphoenix]

Thanks Fotis1991, works a treat,