Conditional formatting a cell
 

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: http://www.excelforum.com/member.php...o&userid=28792
View this thread: http://www.excelforum.com/showthread...hreadid=514758

Conditional formatting a cell
 

Can you give us an example?

Hans

Conditional formatting a cell
 

thanks for your post.

The solution was : or(and(a10, b10, c10), and(a1<0, b1<0, c1<0))

Chiris


--
loopoo
------------------------------------------------------------------------
loopoo's Profile: http://www.excelforum.com/member.php...o&userid=28792
View this thread: http://www.excelforum.com/showthread...hreadid=514758