Need a simple IF stmnt (I think).

Zac

Well-known Member
Joined
Feb 20, 2002
Messages
796
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
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
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 /board/images/smiles/icon_smile.gif ).

Thanks for your help as always,
Mike

Mike,

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

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
 
Upvote 0
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
 
Upvote 0
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.
/board/images/smiles/icon_smile.gif

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
 
Upvote 0
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 :).
 
Upvote 0

Forum statistics

Threads
1,213,561
Messages
6,114,316
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top