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 th
formula (C1), function of the sign of the two members (value1 in A1
value2 in B1) ?


Thanks in advance,
Chri

 

[flummi]

Can you give us an example?

Hans

 

[loopoo]

thanks for your post.

The solution was : or(and(a1>0, b1>0, c1>0), and(a1<0, b1<0, c1<0))

Chiri