Hi everyone,
I know this is a rather easy question, but quite frankly, my brain is kinda fried and google isn't exactly helping me find the solution.
Column A contains names.
Column H contains data validation list consisting of "Pass" and "Fail".
If the user selects "pass" from H2 (for example), I want the name in A2 to be one color; Conversely, I want it to be a different color if "Fail" is selected. I'm pretty sure this is 2 separate conditional formats that can be set to the same cells... I just need to get the right formula for one and then modify it to work for the other and just choose a different color.
Any help would be appreciated!
Thanks!
Bookmarks