software

I have a spread sheet with lots of data. The top row of each column looks for
the max number in that column. Is there a way for excel to warn me when
entering data that the number I just entered was max in that column. That
would really help me out. Thanks

One way would be to keep this top row always in view by using quot;Freeze
Panesquot;.

That way you could immediately see it display there as you enter that max
number.

Another option might be to use quot;Conditional Formattingquot; on all the rows, so
that the max entry would perhaps turn red as it was entered.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

quot;billy boyquot; gt; wrote in message
...
I have a spread sheet with lots of data. The top row of each column looks
for
the max number in that column. Is there a way for excel to warn me when
entering data that the number I just entered was max in that column. That
would really help me out. Thanks
Try this:

For an input area of A1:A100
Select that range, with A1 as the active cell

Datagt;Data Validation
Allow: Custom
Formula: =A1lt;gt;MAX($A$1:$A$100)
Error Alert: Information
(enter the message you want displayed)
Click [OK]

That will display the message whenever the new amount is greater than or
equal to the maximum value in Cells A1:A100.

Does that help?

***********
Regards,
Ronquot;billy boyquot; wrote:

gt; I have a spread sheet with lots of data. The top row of each column looks for
gt; the max number in that column. Is there a way for excel to warn me when
gt; entering data that the number I just entered was max in that column. That
gt; would really help me out. Thanks

There are many ways, here is 1:

Select your range (in this case i'm assuming A1:A40), and go to
Format-gt;Conditional Formatting-gt;Check 'Formula Is', then enter this formula:

=A1=MAX($A$1:$A$40)

Make sure (in this case that is) that the active cell is A1. Then choose
whichever formatting you would like.--
Regards,
Davequot;billy boyquot; wrote:

gt; I have a spread sheet with lots of data. The top row of each column looks for
gt; the max number in that column. Is there a way for excel to warn me when
gt; entering data that the number I just entered was max in that column. That
gt; would really help me out. Thanks

Ron,
Where do I put the formula?

quot;Ron Coderrequot; wrote:

gt; Try this:
gt;
gt; For an input area of A1:A100
gt; Select that range, with A1 as the active cell
gt;
gt; Datagt;Data Validation
gt; Allow: Custom
gt; Formula: =A1lt;gt;MAX($A$1:$A$100)
gt; Error Alert: Information
gt; (enter the message you want displayed)
gt; Click [OK]
gt;
gt; That will display the message whenever the new amount is greater than or
gt; equal to the maximum value in Cells A1:A100.
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt;
gt; quot;billy boyquot; wrote:
gt;
gt; gt; I have a spread sheet with lots of data. The top row of each column looks for
gt; gt; the max number in that column. Is there a way for excel to warn me when
gt; gt; entering data that the number I just entered was max in that column. That
gt; gt; would really help me out. Thanks

RagDyer,
Thanks for your help.
Could you tell me how to conditional format. Thats what I would like it to
do, turn red or something.

quot;RagDyeRquot; wrote:

gt; One way would be to keep this top row always in view by using quot;Freeze
gt; Panesquot;.
gt;
gt; That way you could immediately see it display there as you enter that max
gt; number.
gt;
gt; Another option might be to use quot;Conditional Formattingquot; on all the rows, so
gt; that the max entry would perhaps turn red as it was entered.
gt; --
gt;
gt; HTH,
gt;
gt; RD
gt; ================================================== ===
gt; Please keep all correspondence within the Group, so all may benefit!
gt; ================================================== ===
gt;
gt; quot;billy boyquot; gt; wrote in message
gt; ...
gt; I have a spread sheet with lots of data. The top row of each column looks
gt; for
gt; the max number in that column. Is there a way for excel to warn me when
gt; entering data that the number I just entered was max in that column. That
gt; would really help me out. Thanks
gt;
gt;
gt;

That formula goes in the formula field of the Data Validation setup window.

Does that help?

***********
Regards,
Ronquot;billy boyquot; wrote:

gt; Ron,
gt; Where do I put the formula?
gt;
gt; quot;Ron Coderrequot; wrote:
gt;
gt; gt; Try this:
gt; gt;
gt; gt; For an input area of A1:A100
gt; gt; Select that range, with A1 as the active cell
gt; gt;
gt; gt; Datagt;Data Validation
gt; gt; Allow: Custom
gt; gt; Formula: =A1lt;gt;MAX($A$1:$A$100)
gt; gt; Error Alert: Information
gt; gt; (enter the message you want displayed)
gt; gt; Click [OK]
gt; gt;
gt; gt; That will display the message whenever the new amount is greater than or
gt; gt; equal to the maximum value in Cells A1:A100.
gt; gt;
gt; gt; Does that help?
gt; gt;
gt; gt; ***********
gt; gt; Regards,
gt; gt; Ron
gt; gt;
gt; gt;
gt; gt; quot;billy boyquot; wrote:
gt; gt;
gt; gt; gt; I have a spread sheet with lots of data. The top row of each column looks for
gt; gt; gt; the max number in that column. Is there a way for excel to warn me when
gt; gt; gt; entering data that the number I just entered was max in that column. That
gt; gt; gt; would really help me out. Thanks

billy boy... look at my post for how to set up conditional formatting. You
can format the cell to show any color you want.--
Regards,
Davequot;billy boyquot; wrote:

gt; RagDyer,
gt; Thanks for your help.
gt; Could you tell me how to conditional format. Thats what I would like it to
gt; do, turn red or something.
gt;
gt; quot;RagDyeRquot; wrote:
gt;
gt; gt; One way would be to keep this top row always in view by using quot;Freeze
gt; gt; Panesquot;.
gt; gt;
gt; gt; That way you could immediately see it display there as you enter that max
gt; gt; number.
gt; gt;
gt; gt; Another option might be to use quot;Conditional Formattingquot; on all the rows, so
gt; gt; that the max entry would perhaps turn red as it was entered.
gt; gt; --
gt; gt;
gt; gt; HTH,
gt; gt;
gt; gt; RD
gt; gt; ================================================== ===
gt; gt; Please keep all correspondence within the Group, so all may benefit!
gt; gt; ================================================== ===
gt; gt;
gt; gt; quot;billy boyquot; gt; wrote in message
gt; gt; ...
gt; gt; I have a spread sheet with lots of data. The top row of each column looks
gt; gt; for
gt; gt; the max number in that column. Is there a way for excel to warn me when
gt; gt; entering data that the number I just entered was max in that column. That
gt; gt; would really help me out. Thanks
gt; gt;
gt; gt;
gt; gt;

Dave, that worked perfect, but now I'm trying to do the same thng but with
cells i9 thru i39 and i305.
Is that possible?

quot;David Billigmeierquot; wrote:

gt; There are many ways, here is 1:
gt;
gt; Select your range (in this case i'm assuming A1:A40), and go to
gt; Format-gt;Conditional Formatting-gt;Check 'Formula Is', then enter this formula:
gt;
gt; =A1=MAX($A$1:$A$40)
gt;
gt; Make sure (in this case that is) that the active cell is A1. Then choose
gt; whichever formatting you would like.
gt;
gt;
gt; --
gt; Regards,
gt; Dave
gt;
gt;
gt; quot;billy boyquot; wrote:
gt;
gt; gt; I have a spread sheet with lots of data. The top row of each column looks for
gt; gt; the max number in that column. Is there a way for excel to warn me when
gt; gt; entering data that the number I just entered was max in that column. That
gt; gt; would really help me out. Thanks


Ron,
Thanks, it works perfect and I was wonder what the formula would be for
cells like a1 thru a20 then skip a few cells then a30 thru a40?
Thanks again
quot;Ron Coderrequot; wrote:

gt; That formula goes in the formula field of the Data Validation setup window.
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt;
gt; quot;billy boyquot; wrote:
gt;
gt; gt; Ron,
gt; gt; Where do I put the formula?
gt; gt;
gt; gt; quot;Ron Coderrequot; wrote:
gt; gt;
gt; gt; gt; Try this:
gt; gt; gt;
gt; gt; gt; For an input area of A1:A100
gt; gt; gt; Select that range, with A1 as the active cell
gt; gt; gt;
gt; gt; gt; Datagt;Data Validation
gt; gt; gt; Allow: Custom
gt; gt; gt; Formula: =A1lt;gt;MAX($A$1:$A$100)
gt; gt; gt; Error Alert: Information
gt; gt; gt; (enter the message you want displayed)
gt; gt; gt; Click [OK]
gt; gt; gt;
gt; gt; gt; That will display the message whenever the new amount is greater than or
gt; gt; gt; equal to the maximum value in Cells A1:A100.
gt; gt; gt;
gt; gt; gt; Does that help?
gt; gt; gt;
gt; gt; gt; ***********
gt; gt; gt; Regards,
gt; gt; gt; Ron
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;billy boyquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I have a spread sheet with lots of data. The top row of each column looks for
gt; gt; gt; gt; the max number in that column. Is there a way for excel to warn me when
gt; gt; gt; gt; entering data that the number I just entered was max in that column. That
gt; gt; gt; gt; would really help me out. Thanks