Conditional formatting is one of those features that sounds simple until you try to explain it, and this question captures the exact moment where most spreadsheet users hit a wall. You have a dropdown in cell A, a word in cell B, and you want that word to change its appearance based on what you pick. That is not a complicated request. It is a practical, everyday need. And yet, the default reaction from most people is to assume it requires a formula, a macro, or some hidden setting they have not found yet. It does not. The answer is already built into the tools you are using, and the moment you see it, the whole process clicks into place.
What this user is really asking for is a way to make their spreadsheet respond to them, not the other way around. They are not trying to build a dashboard or automate an entire workflow. They just want cell B to visually react to cell A, so that the data reads clearly at a glance. That is the kind of request that separates people who use spreadsheets as digital paper from people who use them as thinking tools. The good news is that this is not a hard problem to solve. The formatting rule is tied to the dropdown value, not to the cell content itself. That means you are not writing a formula that checks what is in cell A and then outputs something different in cell B. You are telling the spreadsheet to look at cell A, and based on that choice, change how cell B looks. That is a subtle but important distinction, because it means the word in cell B stays exactly as it is. You are not changing data. You are changing presentation.
The practical takeaway here is that conditional formatting is not just for highlighting duplicates or coloring in a progress bar. It is the bridge between raw data and meaningful information. When you set up a rule that says "if cell A says 'Pending,' make cell B red," you are building a visual language that anyone can read. No one needs to ask what the colors mean, because the colors carry the meaning. That is why this question matters, even though it is small. It represents a shift in how people want to interact with their spreadsheets. They do not want to memorize rules or trace formulas. They want the spreadsheet to do the interpreting for them.
So if you are the one asking this question, or if you have been putting off learning how to make your own data respond to your choices, here is where to start. Select cell B, open the conditional formatting menu, and choose "New Rule." From there, pick "Use a formula to determine which cells to format," and enter a formula that references cell A, like `=$A$1="Option 1"`. Then set the fill color or font style you want. That is it. You can add as many rules as you need, one for each dropdown option, and each one will fire automatically the moment you change your selection. You are not writing a formula in cell B. You are teaching the spreadsheet to watch cell A and react. That is the difference between a static table and a responsive tool. And once you see it work, you will wonder why you ever put up with a spreadsheet that just sat there.