Macro to find value, and alert if conditions arent met

Hello

I have a column of data (accounts) that at times can be very long. If the amount in the (account) column is a certain value [1520], there must be data in a nearby column (project), unless it is in a certain (group).

Easyist put:
Account 1520 is what the search is for. If it find thats, then it needs to look at the project cell and see if there is any data. The project cell can be left blank only if on the same row, the column named (groups) contains either 1,2,3,4,5 nothing else.

If it is not 1-5 it can not be blank in the project column.

If there is an error where the 1520 is found, and the project is blank and it shouldnt be, I want a popup alert.

I imagine this could be done with a simple if then, however the file is a template that users fill in and mail to me, therefore changing rows and columns isnt an option, as it might also currupt the upload into the data system.

Anyone have ideas? Does this make sense?

here is an example.. its not the actual file, but gets the point..

Dom,

Thanks for your help. I should have specified which might make this a little easier. The input cells for "Groups" starts at E18, "Accounts" start at G18, and "Projects" start at J18.

To make this slightly more difficult, the Accounts that dont require projects are not as easy as 1-5, I would need to manually enter in 14 different "group numbers"

Also, since the account number wont change, is there a way to make the inputbox account always the same rather than manually entering it each time the macro is ran?

Thanks soo much!

here is a better example.. if the range for group is editable so I can specify which group numbers are allowed to not have a project.