Conditional Formatting referencing multiple sheets

worlockb

New Member
Joined
Nov 9, 2019
Messages
4
https://drive.google.com/file/d/1lXfnDfZNhTXRkafUyrZOM8PgLc5tzHWm/view?usp=sharing

Hi Excel Users!

I need some assistance in having a formula created that will highlight a cell red when the following conditions are met, however, some of the information is on different sheet tabs.

On Saturday Schedule tab, I need the employee name (column's F and K to be highlighted if the Saturday (Cell B2 & G2) matches the Employee Name and Saturday (Column B and Column H) on the Scheduled Time Off tab. That will alert that they are unable to work that Saturday.

I appreciate your help!

Thanks.
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
39,053
Office Version
365
Platform
Windows
Select F4:F10 > conditional formatting > New rule > use a formula > use
=ISNUMBER(MATCH(F4&"|"&$B$2,INDEX(Agents&"|"&Saturday,0),0))
Select your format > OK

and then the same for K4:K10 & use
=ISNUMBER(MATCH(K4&"|"&$G$2,INDEX(Agents&"|"&Saturday,0),0))
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
39,053
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,096,293
Messages
5,449,497
Members
405,569
Latest member
deanro

This Week's Hot Topics

Top