DATA VALIDATION?

[ChrisMiller1980]

I have many different cells that formulate simple equations on my spread sheet. I would like for three of them to not formulate without another cell being marked X or x.  How would I do this?

[#2 · Accepted solution]

@ChrisMiller1980 

Let's say you now have

=formula

and that you want the cell with this formula to look blank if C2 does not contain "x" or "X". Change the formula to

=IF(UPPER(C2)="X", formula, "")

[#3]

THANK YOU FOR YOUR HELP.