IF Target cell No, then 0 , IF Yes then I can type in any number

Hi there

Hopefully someone can help me out here.

I have a cell that if it is set to No Then another cell should be set to 0.
But if the same cell is set to Yes then the cell should be 1 OR! any number the user writes in.

Thanks

excel.JPG

If the user entered a number in that cell then it would overwrite the formula that makes that cell say 0 or 1.

BSB

Yes that is my problem.
I need something like Conditional Formatting but for text. Not just color or Font formatting. Is there such a thing ?

Not exactly.

You could get around this with VBA. Using a worksheet change event that fires when cell A1 is changed you could enter 0 in E1 if A1 = No or 1 if A1 = Yes and the user could overwrite the 1 if another number is needed.

Would that work for you at all?

BSB

In theory it sounds like its something that would work. But not sure how it would work in practical. "VBA. Using a worksheet change event that fires when cell A1 is changed "

If there isn't a way to make special cell with text "Write Value" with Condicional Formatting and then tell it to choose that when A1 is Yes or No.

:/

Ahh yes

Thank you very much

Preventing saving is more of a crude bodge than a solution.

Please Login or Register  to view this content.