Change Value of Subsequent Cells Once A Condition Is Met [Closed]

Question

Change Value of Subsequent Cells Once A Condition Is Met [Closed]

Report

strangerarray - Mar 13, 2017 at 01:47 PM
Blocked Profile - Mar 13, 2017 at 04:36 PM

The simplified story:

I have a user input "Start Month" that is between 1-12.

I have Columns A:M labeled accordingly 1-12.

The question:

If the user inputs "1", I want the cell below column 1 to return "A" and below column 2 to return "B", etc.

However,

If the user inputs "2", I want the cell below column 2 to return "A" and then below column 3 to return "B", and so on and so forth...

The caveat:

Really the return value is a formula based on other cells and not the ABC's, but this was the easiest way for me to explain it.

Change Value of Subsequent Cells Once A Condition Is Met
Excel formula change cell color without conditional formatting ✓ - Forum - Excel
Change cell color if condition fails - Forum - Excel
Excel macro to merge cells based on condition ✓ - Forum - Excel
How to change value based on cell color in excel ✓ - Forum - Office Software
Excel click on cell to change value of another cell - Forum - Excel

1 reply

Ask a question

Blocked Profile · Answer 1 · 2017-03-13T16:36:37-0400

Answer 1 / 1

Blocked Profile
Mar 13, 2017 at 04:36 PM

Do you know about "Conditional Formatting"? It does exactly what you are asking. Look on the top ribbon, for conditional formatting, and play with it. Let us know if you need help with that.

Change Value of Subsequent Cells Once A Condition Is Met [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!