Data validation for inventory warning

[RAE123]

Hi,

Im trying to create an inventory sheet in excel 2007 and i want a warning message to pop up if cell B29 total is less than 26. I have an auto sum set up already in cell B29 so when it did not work the first time i thought maybe because i cant have 2 formuals in one cell but i also typed 26 into another cell and tried to referrence using that cell.

can anyone offer any advice?
It would be greatly appreciated.

 

[Scott T]

In C29
change Warning low inventory to what you want displayed. I assumed that if it was equal to or above 26 nothing should be displayed, if you want to display something then replace the "" with what you want displayed for example "over 26 items"

=IF(B29<26,"Warning low inventory","")

 

[63falcondude]

Hello and welcome to the forum.

You wouldn't put the data validation in the cell with a formula in it (B29).

Instead, try highlighting the range of cells that are included in that sum > Data Validation > Allow: Custom > Formula: =SUM(range)>26

Error Alert > Style: Warning

 

[RAE123]

what if i want the actual warning message box to pop up and not just display the warning in that specific cell?

 

[RAE123]

ill try that @63falcondude. thank you!

 

[RAE123]

It worked 63falcondude! Ive been working on this spreadsheet for 2 weeks now and couldnt figure that formula out. You just made my day. thanks so much!

 

[63falcondude]

Great! Glad I could help.