P
Patrick C. Simonds
What I would like to do is have a conditional format which looks at the
value of the cell then find the matching value on the WorkShifts Monday
worksheet (that value would be found in column A and then when it finds that
look at Column U. If the value in column U is "Large" I want to set the cell
shading to blue ( I know how to set the format if the condition is met it is
everything before that I can not figure out).
The range for WorkShifts Monday worksheet is A3:U120. I am assuming that
this would require there to be some sort of VLookUp as part of the
conditional forma.
value of the cell then find the matching value on the WorkShifts Monday
worksheet (that value would be found in column A and then when it finds that
look at Column U. If the value in column U is "Large" I want to set the cell
shading to blue ( I know how to set the format if the condition is met it is
everything before that I can not figure out).
The range for WorkShifts Monday worksheet is A3:U120. I am assuming that
this would require there to be some sort of VLookUp as part of the
conditional forma.