software

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--
loopoo
------------------------------------------------------------------------
loopoo's Profile: www.excelforum.com/member.php...oamp;userid=28792
View this thread: www.excelforum.com/showthread...hreadid=514758Can you give us an example?

Hans
thanks for your post.

The solution was : or(and(a1gt;0, b1gt;0, c1gt;0), and(a1lt;0, b1lt;0, c1lt;0))

Chiris--
loopoo
------------------------------------------------------------------------
loopoo's Profile: www.excelforum.com/member.php...oamp;userid=28792
View this thread: www.excelforum.com/showthread...hreadid=514758