Conditional Formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mr Anonymouse - 01 May 2005 16:04 GMT

I'm getting stuck on something really basic. I want to compare the sum of
two cells with the value of one cell multiplied and, if greater, turn the
cell red.

I'm entering the formula and it's appearing as follows:

=IF+$E$5:$E$6>$E$4*2

It won't work. Anyone tell me what I'm doing wrong?

Thanks

Reply to this Message

JulieD - 01 May 2005 16:20 GMT

Hi

does the formula

=($E$5+$E$6)>($E$4*2)

do what you want?

Signature

Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
...well i'm working on it anyway

> I'm getting stuck on something really basic. I want to compare the sum of
> two cells with the value of one cell multiplied and, if greater, turn the
[quoted text clipped - 7 lines]
>
> Thanks

Reply to this Message

Mr Anonymouse - 01 May 2005 17:10 GMT

That worked a treat. I also got it to work using the 'sum' function.

I think I was looking for too complex an answer to a simple question. Next
time I'll look for the simple answer.

Thanks for taking the time.

> Hi
>
[quoted text clipped - 15 lines]
>>
>> Thanks

Reply to this Message

JulieD - 02 May 2005 17:04 GMT

you're welcome and thanks for the feedback :)

Signature

Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
...well i'm working on it anyway

> That worked a treat. I also got it to work using the 'sum' function.
>
[quoted text clipped - 22 lines]
>>>
>>> Thanks

Reply to this Message