Cell Validation
I need help in trying on what I think is a validation issue. I'm
trying to get excel to prompt the user to enter information in cell B1 if cell A1 contains data. What would be there formula? Thanks for the help. -JD |
Cell Validation
Not being 100% sure of what you are trying to accomplish, this would be one
way of doing what you are looking for. Place this formula in cell B1 =IF(A10,"Please enter value","") As soon as someone typed something in B1, this formula would be overwritten. " wrote: I need help in trying on what I think is a validation issue. I'm trying to get excel to prompt the user to enter information in cell B1 if cell A1 contains data. What would be there formula? Thanks for the help. -JD |
All times are GMT +1. The time now is 06:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com