Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
VALIDATION DATA IN A CELL
Hi, can some one tell me if there's any way I put put some validation or
enforcement in a cell, where users HAVE to input something and it CANT be left blank ? Thanks |
#2
|
|||
|
|||
VALIDATION DATA IN A CELL
What I usually do in a case like that is to use Conditional Formatting to
color the cells RED if they are blank, (ie = < )and they turn white when data is entered in them, then on the next function that depends on that data, say a SUM function, use an IF to condition it, such as......... =IF(COUNT(A1:A10)=10,SUM(A1:A10),"Red Cells must contain values") Vaya con Dios, Chuck, CABGx3 "Chris" wrote in message ... Hi, can some one tell me if there's any way I put put some validation or enforcement in a cell, where users HAVE to input something and it CANT be left blank ? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List, Data Validation, unlocked cell, protected sheet..... | New Users to Excel | |||
drop downs & data validation | Excel Discussion (Misc queries) | |||
6 Data Validation lists depending on 1 cell value | Excel Discussion (Misc queries) | |||
Splitting Data in a Cell | Excel Worksheet Functions | |||
Data Validation Window? | Excel Discussion (Misc queries) |