Conditional formatting a cell

[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

[avveerkar]

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

[loopoo]

Thanks a lot for your post.

The solution was something like OR (And(a1<0, b1<0, c1<0), and(a1>0, b1>0, c1>0))

Chris