Entire Row Blink when condition meet

This is possible, though I question if it's ideal. If you're trying to prevent an extra payment to him, then you can use data validation with a formula against the cell containing the remaining balance. This will cause anything entered to be rejected by Excel and a dialog box will pop up with a warning.

Here's how to do it. Let's say the remaining balance is in B1, and you want to prevent entries in B2 for a 0 balance. Click cell B2, click the data tab and select validation. Click the Allow dropdown, then click custom. Enter the following formula in the formula box:=B1<>0. Click the Error Alert tab of the dialog box, enter Balance Error as the title, and The remaining balance is 0, so further entry is not permitted. as the Error Message. Click OK.

Can you post a sample of your workbook?

In the lower right hand corner of the reply text box, click Go Advanced, then click the paperclip icon and follow the prompts.

This doesn't look like what we've been discussing. This appears to be for landlines and cell phones, and I'm not sure where your data entry will occur. It appears that you want something to happen when you enter values in the mobile and land line columns, and lock out further entry when the consumed yearly balance is zero. It also appears you want to make copies of the data somewhere on another sheet, but I'm not exactly sure how and when you'd like that to happen.


Please take a minute to include a description in the sample file you sent me to describe with arrows, text boxes, diagrams or whatever else will help make the point clear. In the meantime, the data validation is a simple matter, and I've applied it to the attached file for the presumed data entry area.

To move data to another sheet upon entry of certain values will probably necessitate a macro. If that's the case, I will need clear information about exactly when that should occur, and exactly what should happen.