Conditional formatting a cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

loopoo - 21 Feb 2006 07:55 GMT

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

Signature

loopoo

Reply to this Message

avveerkar - 21 Feb 2006 08:46 GMT

loopoo Wrote:

> Hi everybody!
>
[quoted text clipped - 12 lines]
> 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

Signature

avveerkar

Reply to this Message

loopoo - 21 Feb 2006 09:46 GMT

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

Signature

loopoo

Reply to this Message