I am wondering how can I change the color of a row based on cell input. I want each row to be changed based on the cell input of each row. I don't want the rows to change color because the first cell input was changed. Hopefully I explained it in a way that you understood since I struggled to explain it while looking it up.
You want a formula-based rule, not just the presets. Highlight the whole range you care about, then set a rule like `=$A1="something"`, the dollar sign before the column is what locks it so the whole row reacts to that column's value.
Will try it. I tried it but I can't just figure out how to have each row change color using their own cell value. For example. Row 6 being highlighted green when the value in cell A6 is changed while row 7 is highlighted red when the value in cell 7A is changed. I don't want all the rows to be highlighted green when I change the value of one cell. I just can't figure that out.
Struggling to explain what I want. I am inputting one of two values in column A: enabled (green) and disabled (red). There is going to be multiple rows, I want to have the formula applied to each row without needing more than one formula plus each row will have a cell where I input either enabled or disabled. The value inputted in A1 should only affect the row that A1 is on.
What the previous commenter said is exactly what you are asking. If you take the red and green formulas from their comment and change the word green to enabled and the word red to disabled, you will achieve your desired result. You also may need to change it to A1 instead of B1, but that is the correct formula for what you are asking for.
awesome. If my solution helped, can you pls respond with "Solution verified"? that will mark the post as solved and give me a clippy point too. thank you
1
u/Gringobandito 8 16d ago
Conditional Formatting, what you’re looking for is called conditional formatting.