Data validation error

[OneAbhishek]

Hi everyone
I want to put data validation in range e10:e80 to allow data entry if d10:d80 are not blank. I am using formula =not(isblank(d10)). Ifs working fine but if convert my range a10:f80 to a table e10 shows a data validation error sign untill d10 and e10 are blank (also for all other cells with same setting ). Its still working fine but i dont want error sign. The error sign only exist for table. I don't know whats going wrong. Can anyone help ?

 

[Fluff]

If you select E10:E80 then click on the warning icon, you can select to not show the error.

 

[OneAbhishek]

If you select E10:E80 then click on the warning icon, you can select to not show the error.

Thank you i did the same. I wanted to know if it doesn't even show any error.
Thank you again for your reply.

 

[Fluff]

If you clear the error flag, then it won't show any error.

 

[OneAbhishek]

If you clear the error flag, then it won't show any error.

There is an issue in this. If the workbook refreshes anyhow ( like if i reopen the file, delete content of the cells ), the error flag comes again and i need to clear the flag again. Its not a parmanent solution I don't want to do it again and again. Please find any other solution !

 

[Fluff]

I cannot replicate that behaviour, but there is no other option of turning of that message that I know of.