Quote Originally Posted by loopoo
Hi everybody!

I have this situation:

A1 B1 C1 (the cells in a sheet)

value1 value2 formula

formula (in C1) is value1 - value2.

My question is how can I condition the format of the cell with the formula (C1), function of the sign of the two members (value1 in A1, value2 in B1) ?


Thanks in advance,
Chris
Question is not very clear. Do you want to format C1 depending on values of A1 and B1? Like C1 should be blue if value1 ( in A1) is negative and red if value2 is negative and say orange, when both are negative?

A V Veerkar