Hi all,
I'm making a tracking sheet for tasks in progress. I have a column for status, where I have conditional formatting on to change the colors based on certain data, like 'ON HOLD' is red, 'DONE' is green, 'IN PROGRESS' is yellow, etc.
What I want to do is set all relevant cells in any given row to change to the same color, so if the tracking cell is set to yellow, then I want the other cells in that row to also turn yellow.
I feel like there's probably a very easy way to do this, but damned if I can find it.
On a separate note, I've been trying to post this question for several hours now. We all know what company this is; I'm not expecting miracles here. The issue comes up when I try to type in my question, wherein the site sooner or later pops up a message that it's saved the data so far; when I try to post the message, another popup informs me that it failed to post, and I can't post until I fix the highlighted issues, which it fails to highlight, but the only thing that's still popped up at that point is the message that it's saved the data that's been input thus far - clearing that, and trying to post then comes up with a different error, saying that I've had the audacity to try to post twice in less than five minutes, despite the fact that the site has never permitted me to post anything because it can't stop failing.
If someone could perhaps tweak the site's coding so it can fail more efficiently, that will make the end-user experience less harrowing.
I apologize for the sarcasm, but I'm genuinely annoyed at this point at how much of my time this defective website has wasted.
