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

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
38,872
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
38,872
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,095,952
Messages
5,447,526
Members
405,455
Latest member
nixonphotos

This Week's Hot Topics

Top