Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for empty cell
I am trying to put a validation into a cell that would refer to two other
cells. I want to make it so if I try to type text into B9 cell, I either have to put an X in cell A10 or A13 first. I sure there's a way to do this, but I can't figure it out. Any ideas? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for empty cell
Select B9, apply data validation:
Allow: Custom Formula: =OR(A10="x",A13="x") Uncheck "Ignore blank" OK Test it out .. -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:365 Subscribers:65 xdemechanik --- "collyer3" wrote: I am trying to put a validation into a cell that would refer to two other cells. I want to make it so if I try to type text into B9 cell, I either have to put an X in cell A10 or A13 first. I sure there's a way to do this, but I can't figure it out. Any ideas? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for empty cell
I cannot think how to do this at the moment with Data Validation.
Others may give you a VBA solution Meanwhile, how about using Conditional Formatting ? With B9 as the active cell use this rule: =COUNTA(A10,13)<1 and set a fill color to alert the user of an error. best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "collyer3" wrote in message ... I am trying to put a validation into a cell that would refer to two other cells. I want to make it so if I try to type text into B9 cell, I either have to put an X in cell A10 or A13 first. I sure there's a way to do this, but I can't figure it out. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
format a cell with a formula so an empty reference cell shows blan | Excel Discussion (Misc queries) | |||
formula, move to previous cell when the current cell=0 or empty | Excel Discussion (Misc queries) | |||
How do I leave formula cell blank if 2nd reference cell is empty? | Excel Discussion (Misc queries) | |||
Can I empty the cell who has formula in it | Excel Worksheet Functions | |||
Is there a way to go to next empty cell in a formula | Excel Worksheet Functions |