Forum Discussion
I need two responses to occur in cells to make sure two rules are followed in a column in Excel
I have a Table established with the following column headings: Date Reviewed, Accts Opened, Forms Uploaded. In the Forms Uploaded column of cells I need two factors to occur. One I have established is through Data Validation, which is to compare the value entered in "Forms Uploaded" to the value entered in "Accts Opened" and to return an error message if the value in "Forms Uploaded" is greater than the value in "Accts Opened". This is working fine.
Here is the one that I truly need assistance with. In the column for "Forms Uploaded" I also want Excel to warn me if I leave any of these cells blank. It is possible that the value entered could be zero, however, the cell cannot be empty. The data input into this table will be via the Excel generated Form.
I know there is a way to use the " "If Blank" or the "If (cell)="" " function, however, this only works if you click in a cell outside of the input cells and reference the input cells, then the error message populates to the cell where the formula has been entered. This isn't what I need done.
I have searched online for an answer and most point to VBA coding. I have tried with several codes and changed the cell ranges, however, they aren't working (or I may be doing something wrong since I am not skilled on VBA).
I appreciate any help you can lend.