Now that I've ripped my hair out, I'm turning to the forum for help. I'm trying to use the Conditional Formatting feature when two conditions must both be satisfied.
In Column A, I have listed 20 Employees' Names
In Column B, I have listed the offices where those 20 employees work
In Column C, I have listed how many performance reviews that the particular employees have had.
Whenever both "Fresno" is listed in Column B AND the number '2' or higher is listed in Column C, I want to highlight that employee in Column A via conditional formatting (in the alternative, I would be happy if the formatting just applied to the applicable cell in Column B).
In short, I want to have Excel highlight for me (via conditional formatting) Fresno employees with 2 or more performance reviews.
Any help you can give me here would be much appreciated.
Thanks
Bookmarks