Need a simple IF stmnt (I think).

[Zac]

Having a mental block this morning.

From B5:B1000 I have values that result from
a MAX function. If when all is said and
done, and all my vaules in this range are
> $0.00, I want to turn B1 Green. If not,
then RED. A simple flag to tell me the
Spreadsheet is completed. (Unless you have
some other brilliant way to show this, like
having fireworks go off or something ).

Thanks for your help as always,
Mike

[Aladin Akyurek]

On 2002-03-14 05:04, Zac wrote:
Having a mental block this morning.

From B5:B1000 I have values that result from
a MAX function. If when all is said and
done, and all my vaules in this range are
> $0.00, I want to turn B1 Green. If not,
then RED. A simple flag to tell me the
Spreadsheet is completed. (Unless you have
some other brilliant way to show this, like
having fireworks go off or something [img]/board/images/smiles/icon_smile.gif[/img] ).

Thanks for your help as always,
Mike

Mike,

How can you be Mike and Anonymous at the same time .

Why not use conditional formatting?

Activate B1.

Activate Format|Conditional Formatting.

Choose "Formula Is" for Condition 1.

Enter in the formula box:

=SUM(B5:B1000)>0.00

Activate Format.
Select green on the Patterns tab.
Click OK.
Activate Add.
Choose 'Formula Is' for Condition 2.
Enter as formula:

=SUM(B5:B1000)<0.00

Activate Format.
Select red on the Patterns tab.
Click OK, OK.

Aladin

[Zac]

Tried your idea, but after reading your suggestion, I don't think it will work.
Don't think we should be looking at the SUM > 0.00, or <$0.00..
If any of the values are =$0.00 from B5:B1000,
Then I need to expedite my suppliers and push them to complete their RFQ for us. The Green "flag" will tell me that I've posted all the costs required to complete the customer quote. Beats having to scroll down the column. Hope that helps.

Have no idea how I can be Anonymous!!!
I use ZAC as a nickname, and Mike's my given.


I'll await your reaponse.
ZAc

[Aladin Akyurek]

On 2002-03-14 05:56, Zac wrote:
Tried your idea, but after reading your suggestion, I don't think it will work.
Don't think we should be looking at the SUM > 0.00, or <$0.00..
If any of the values are =$0.00 from B5:B1000,
Then I need to expedite my suppliers and push them to complete their RFQ for us. The Green "flag" will tell me that I've posted all the costs required to complete the customer quote. Beats having to scroll down the column. Hope that helps.

Have no idea how I can be Anonymous!!!
I use ZAC as a nickname, and Mike's my given.
[img]/board/images/smiles/icon_smile.gif[/img]

I'll await your reaponse.
ZAc

You're right.

Make the first formula:

=MIN(B5:B1000)>0.00

and, the second:

=MIN(B5:B1000)=0.00

Aladin

[Zac]

ALadin,

Thanks for your help, that worked.
Believe it or not I tried that formula initially, but I had a type-O and it failed.
I'm awake now .