Scenario: I have a Project A Plan sheet that has a field for Bill Rate and Role. This bill rate value is pulled in from a Client A Rate sheet via vlookup based on the value in the Role column on the project plan sheet. This formula is currently working fine.
The Project A Plan sheet also has a column for employee name (which isn't used in the above formula but is important to the use case).
I also set up 3rd sheet we'll call Min Rate sheet that has 2 columns- Employee Name and Minimum Rate for each employee.
For this use case, I wanted to see if I could add a conditional formatting to the Bill Rate cell (on the Project Plan sheet) that compares the Bill Rate value to the Minimum Rate cell for an employee on the Min Rate sheet that makes the Bill Rate cell red if the Bill Rate is less than the minimum Rate.
Is this or something similar possible in SS?
