View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
loopoo
 
Posts: n/a
Default 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