I am trying to get a cell in column A to be highlighted if the corresponding cell in column B contains a certain value. It's easy enough conditional formatting column B on its own but I would like to carry the colour across to column A no matter what value is in the A column.
Say "Joe" is working sat, sun, mon and not working tue, wed, thu, fri, his name is in column B across from the the days he is working labeled in column A. I would like to highlight the days as well as his name whenever he is "working".
I hope this makes sense. I look forward to hearing if anybody has created or used a formula in this way before.