How to calculate number of rows containing any colored cells?

[Hol_dav]

I am wondering if there is a VBA/macro that I can run to count the number of rows in my table that contain any colored cells?

My research seems to only turn up code for counting colored cells, but I need to count the entire row as 1, regardless of how many or what color cells are contained.

Please help me!

 

[James006]

Hi,

How are these cells colored ? manually or conditional formatting ?
What is the rule which differentiates these cells ?

 

[awoohaw]

the rule you use to highlight the cells will be the rule to calculate them.

 

[Hol_dav]

Hi,

How are these cells colored ? manually or conditional formatting ?
What is the rule which differentiates these cells ?

Hi!

They are colored manually.

Data Quality Notes – When to Highlight Data Quality Issue

• Column A (Recruiters) & S (Coordinators)
  • Blanks or Multiple Names Assigned
• Columns B (Job Ref ID) & C (Job Creation Date)
  • If Job Creation Date is greater than 90 days from day report is generated
• Columns F (Service Line) & G (Practice Area/Campus/SSL)
  • Blanks
• Columns I (Job Status) & J (Status)
  • Status mismatch (see below for correct status matches, anything else is mismatch)
    • Created, Interview, Offer, Sourcing = Open
    • On Hold = On Hold, Pipeline
    • Filled = Internal Hire, External Hire
    • Cancelled = Cancelled
• Column L (Is Job Published)
  • If Job Status = Filled or Cancelled and Column L is true
• Columns X, Y, Z, AA, AB, AC
  • If Job Status = Filled or Cancelled and value is greater than 0

Color Key

• Yellow = Data not populated
• Red = Job Status / Job Details Status Field Inconsistency
• Blue = Aged requisition open for 90+ days
• Orange = Multiple recruiters assigned
• Purple = Job ad needs to be unposted against req in inactive status
• Brown = Candidates need to be appropriately dispositioned against req in inactive status
• Green = Req in Filled status but no candidate in Hired status

 

[awoohaw]

Your color key contains your conditional formatting rules. Those rules can also be used for reporting. Please get the bb2xl addin and post a sample or a copiable sample (Not an image). Its a lot of work for someone to have to completely build a worksheet 30 columns wide and fill it with dummy data. You can anonymize PII.

 

[Hol_dav]

Your color key contains your conditional formatting rules. Those rules can also be used for reporting. Please get the bb2xl addin and post a sample or a copiable sample (Not an image). Its a lot of work for someone to have to completely build a worksheet 30 columns wide and fill it with dummy data. You can anonymize PII.

Yes of course! I am not sure that system admin will let me download bb2xl addin though - is there a different way?

 

[awoohaw]

Yes of course! I am not sure that system admin will let me download bb2xl addin though - is there a different way?

There are suggestions for debugging hte downloads,etc. in the xl2BB faq test area, unfortunately I don't have the link handy.

 

[Hol_dav]

Recruiters	Job Ref ID	Job Creation Date	Service Line	Practice Area/Campus/SSL		Job Status	Status	Coordinators	Hiring Managers
	R1010173	9/15/2022​				CREATED	Open		Deep
	R1013816	9/20/2022​				CREATED	Open		Stephen
	R1010662	8/18/2022​				CREATED	Open		Destiny
	R1011173	8/24/2022​				CREATED	Open		Destiny
	R1014085	9/20/2022​	Media	Media Effectiveness		SOURCING	Internal Hire		Yuling
	R0995484	4/21/2022​	Solutions			ON_HOLD	Open		Samuel
	R0944018	3/26/2021​	Solutions	Solutions Ecosystem & Growth Operations		OFFER	Open		Masako
	R0943410	3/24/2021​	Microsoft	Media Effectiveness		ON_HOLD	On Hold		Gary
	REF20444N	4/8/2022​	Creative	Integrated Production		CREATED	Open		Brooke
	R1000205	5/24/2022​	Media	Media Effectiveness		ON_HOLD	On Hold		Michael
	R1008992	8/1/2022​	Media	Performance Marketing		ON_HOLD	On Hold		Eric
	R0960324	8/11/2021​	Microsoft	Media Effectiveness		ON_HOLD	On Hold		Xiaoyuan
	R0949060	5/11/2021​	Creative	Client		OFFER	Open		Ashley
	R0992670	3/25/2022​	Creative	Integrated Production		OFFER	Open		Concetta
	R0964913	9/28/2021​	Microsoft	Media Effectiveness		ON_HOLD	On Hold		Christina
	R1010513	8/16/2022​	Creative	Client		CREATED	Open		Gwyn
	R1013449	9/15/2022​	Creative			OFFER	Open		Sheena
	R0997473	5/4/2022​	Media	Media Effectiveness		ON_HOLD	On Hold		Jonida
	R1010768	9/16/2022​	CXM	Activation		INTERVIEW	Open		Matthew
	R0949279	5/25/2021​	Functions	Operations		OFFER	Open		Delaney
	R1001083	6/1/2022​	Media	Media Effectiveness		ON_HOLD	On Hold		Christina
	R1011058	8/23/2022​	CXM	Activation		ON_HOLD	On Hold	Deborah ,Holly	Courtney
	R1015712	10/7/2022​				OFFER	External Hire		Brittany
	R1015426	11/8/2022​				CREATED	Open		Antoinette
	R1023675	1/19/2023​				CREATED	Open		Marcia
	R1020635	1/18/2023​				CREATED	Open		John
	R1014081	10/17/2022​				CREATED	Open		Lacey
	R1017938	11/4/2022​				CREATED	Open		Olivia
	R1018741	11/12/2022​				CREATED	Open		Olivia
	R1018492	11/10/2022​				CREATED	Open		Cara
	R1021885	12/21/2022​				CREATED	Open		John
	R1021886	12/21/2022​				CREATED	Open		John
	R1023192	1/14/2023​				CREATED	Open		Jacob
	R1020258	12/1/2022​				CREATED	Open		Philip
	R1023897	1/21/2023​				CREATED	Open		Ana
	R1022030	12/23/2022​				CREATED	Open		Patrick
	R1015889	10/12/2022​				CREATED	Open		Craig
	R1015729	10/17/2022​				CREATED	Open		Andrew
	R1015728	10/17/2022​				CREATED	Open		Berlin
	R1015730	10/17/2022​				CREATED	Open		Jessica
	R1015725	10/17/2022​				CREATED	Open		Kade
	R1015781	10/17/2022​				CREATED	Open		Wittney
	R1017218	1/24/2023​				CREATED	Open		Philip
Chavon	R1006227	7/12/2022​	CXM	Experience & Commerce		ON_HOLD	Open		Seetharamam
Diane	R0998065	5/7/2022​	Creative	Integrated Production		ON_HOLD	Open		Suzanne
Diane	R1003089	6/17/2022​	Creative	Brand & Experience		ON_HOLD	Open		Zoe
Diane	R1009328	8/4/2022​	Creative	Operational Excellence		ON_HOLD	Open		Zoe
India	R1013061	9/8/2022​	Media	Media Effectiveness		ON_HOLD	Open		Robert
Katie	R1003934	6/23/2022​	Creative	Operational Excellence		ON_HOLD	Open		Andrea
Kevin	REF23571W	9/16/2022​	Media	Performance Marketing		SOURCING	Pipeline
Kevin	REF23572T	9/16/2022​	Media	Performance Marketing		SOURCING	Pipeline
Linda	REF22822L	7/29/2022​	Media	Performance Marketing		SOURCING	Pipeline		Octavio
Linda	REF23568A	9/16/2022​	Media	Performance Marketing		SOURCING	Pipeline
Rachel	REF21305C	5/18/2022​	CXM	Experience & Commerce		SOURCING	Pipeline		Jared
Adam	R0992863	3/28/2022​	CXM	Experience & Commerce		ON_HOLD	Open	Ihab	Jill
Adam	R0999116	5/17/2022​	CXM	Experience & Commerce		ON_HOLD	Open	Ihab	Jill
Adam	R1004496	6/28/2022​	CXM	Experience & Commerce		ON_HOLD	Open	Ihab	Jill
Adam	R1013566	9/16/2022​	CXM	Client		INTERVIEW	Pipeline	Deborah	Jonathan
Amy	R1013697	9/15/2022​	Media	Growth		OFFER	External Hire	Deborah	Elizabeth
Kimberly	R1008256	7/26/2022​	CXM	Marketing Tech, Data Mgt		INTERVIEW	On Hold	Deborah	Anand
Meagan	R1002403	6/11/2022​	Creative	Brand & Experience		ON_HOLD	Open	Jennifer	Zoe
Meagan	R1004939	7/1/2022​	Creative	Brand & Experience		ON_HOLD	Open	Jennifer	Zoe
Rachel	R1013004	11/8/2021​	CXM	Experience & Commerce		ON_HOLD	Open	Ihab	Peter
Tracie	R1008810	8/9/2022​	Functions	Finance		ON_HOLD	Open	Rachel	ShiYi
Adam	R1012992	9/8/2022​	Media	Investment Mgt		OFFER	Open		Sara
Adeel	R0994991	4/11/2022​	Media	Media Effectiveness		INTERVIEW	Open		Omid
Aleta	R0994382	4/6/2022​	Media	Media Effectiveness		OFFER	Open		Katherine
Anabel	R0999801	5/20/2022​	Media	Investment Mgt		INTERVIEW	Open		Marc
Corinna	REF21820F	6/13/2022​	MKTG Sports/DSI			SOURCING	Open
Desiree	R0999452	5/18/2022​	CXM			ON_HOLD	On Hold		Sherri
Elizabeth	R1002776	6/14/2022​	Media	Performance Marketing		OFFER	Open		Emery
Elizabeth	R0967032	10/14/2021​	Media	Performance Marketing		ON_HOLD	On Hold		Katherine
Emily	R0995834	4/19/2022​	Media	Investment Mgt		ON_HOLD	On Hold		Xavier
Grace	R0998042	5/6/2022​	Media	Performance Marketing		INTERVIEW	Open		Bruce
India	R1009137	8/2/2022​	Media	Media Effectiveness		SOURCING	Open		Keith
Jared	REF18106A	2/1/2022​	Functions	HR		ON_HOLD	Pipeline
Jenna	EV REF22788C	7/28/2022​	Media	Investment Mgt		INTERVIEW	Open
Jenna	EV REF22789A	7/28/2022​	Media	Investment Mgt		OFFER	Open
Jessica	R1012564	9/5/2022​	Media	Media Effectiveness		SOURCING	Open		Jingping
Joanna	REF19840E	4/1/2022​	Creative			SOURCING	Open		Peter
Kevin	R1011827	8/30/2022​	Media	Media Effectiveness		OFFER	Open		Yuling
Kevin	R1007823	7/22/2022​	Media	Media Effectiveness		SOURCING	Open		Kaila
Linda	R0997600	5/4/2022​	Media	Performance Marketing		OFFER	Open		vivian
Linda	R1007718	7/21/2022​	Media	Performance Marketing		SOURCING	Open		Alexandra
Lindsay	R0998203	7/11/2022​	Creative	Social Influencer, PR		CREATED	Open		Rebecca
Madison	R1011318	8/24/2022​	Creative	Client		OFFER	Open		Ashley
Madison	R1014471	9/25/2022​	Creative	Client		SOURCING	Open		Stephanie
Meagan	R1002142	6/9/2022​	Creative	Brand & Experience		ON_HOLD	On Hold		Zoe
Sabrina	R0996690	5/2/2022​	Functions	HR		ON_HOLD	On Hold		Destiny
Sarah	R1013336	9/13/2022​	Creative	Client		CREATED	Open		Peter
Anthony	R0999451	5/18/2022​	CXM	Products		ON_HOLD	On Hold	Rachel
Amanda	R1008998	8/3/2022​	Functions	Technology		ON_HOLD	On Hold	Rachel	Jyoti
Amanda	R1012716	9/7/2022​	Functions	Global Technology		ON_HOLD	On Hold	Rachel	Pradeep
Amanda	R1002012	9/16/2022​	Functions	Operations		ON_HOLD	On Hold	Rachel	Monica
Amanda	R0999503	5/19/2022​	Media	Operations		ON_HOLD	On Hold	Rachel	Kedma
Amanda	R1011292	8/24/2022​	Functions	HR		ON_HOLD	On Hold	Rachel	Katie
Amy	R0994159	4/5/2022​	CXM	Growth		INTERVIEW	Open	Deborah	Michel
Anthony	R1005422	7/6/2022​	Functions	Legal		ON_HOLD	On Hold	Rachel	Miri
Anthony	R0993551	3/31/2022​	Functions	Finance		CREATED	Open	Rachel	Darren
Anthony	R0980904	12/21/2021​	Functions	Technology		ON_HOLD	On Hold	Rachel	Frank
Anthony	R0998490	5/11/2022​	Functions	Technology		ON_HOLD	On Hold	Rachel	Frank
Anthony	R1007511	7/21/2022​	Functions	HR		SOURCING	Open	Rachel	Claire-Marie
Anthony	R0999104	5/31/2022​	Functions	Finance		CREATED	Open	Rachel	David
Anthony	R1010898	8/30/2022​	Functions	Finance		SOURCING	Open	Rachel	David
Anthony	R1003941	6/24/2022​	CXM	Products		ON_HOLD	On Hold	Deborah ,Holly	David
Anthony	R0984456	2/7/2022​	Functions	Technology		ON_HOLD	On Hold	Rachel	Kenneth
Anthony	R0964507	9/28/2021​	Functions	Legal		ON_HOLD	On Hold	Rachel	Elizabeth
Anthony	R0964508	9/28/2021​	Functions	Legal		ON_HOLD	On Hold	Rachel	Elizabeth
Desiree	R1008581	8/11/2022​	Functions	Global Technology		ON_HOLD	On Hold	Rachel	Jessica
Desiree	R1008591	8/11/2022​	Functions	Global Technology		ON_HOLD	On Hold	Rachel	Jessica
Desiree	R1011418	8/25/2022​	Functions	Global Technology		ON_HOLD	On Hold	Rachel	Jessica
Desiree	R1000626	6/1/2022​	Solutions	Social Solutions		SOURCING	Open	Rachel	Gaurav
Desiree	R1008002	7/25/2022​	Functions	HR		SOURCING	Open	Rachel	Katherine
Desiree	R1014203	9/26/2022​	Functions	Technology		INTERVIEW	Open	Rachel	Jonathan
Gigi	R1015145	9/30/2022​	Creative	Client		SOURCING	Open	Jennifer	Felicia
Gigi	R1006676	7/14/2022​	Creative	Integrated Production		SOURCING	Open	Jennifer	Brad
Gigi	R1011036	8/22/2022​	Creative	Integrated Production		INTERVIEW	Open	Jennifer	Brad
Gigi	R1011037	8/22/2022​	Creative	Integrated Production		INTERVIEW	Open	Jennifer	Brad
Gigi	R1006690	7/14/2022​	Creative	Client		SOURCING	Open	Jennifer	Amber
Gigi	REF19635O	3/24/2022​	Creative	Operational Excellence		ON_HOLD	On Hold	Jennifer	Andy
India	R0982145	1/7/2022​	Microsoft	Media Effectiveness		SOURCING	Open	Diana	Vinhhuy-Brian
Ivan	R1013934	9/21/2022​	Functions	HR		SOURCING	Open	María	Sarah
Ivan	R1006229	7/27/2022​	Functions	Global Technology		SOURCING	Open	María	Norris
Ivan	R1008222	7/27/2022​	Functions	Finance		INTERVIEW	Open	María	Cameron
Ivan	R1007309	7/21/2022​	Media	Operations		SOURCING	Open	María	Karel
Ivan	R1008462	7/28/2022​	Functions	Finance		SOURCING	Open	María	Sasha
Kelly	R1009798	8/17/2022​	Functions	Global Technology		ON_HOLD	On Hold	Rachel	Nathan
Kelly	R1009799	8/17/2022​	Functions	Global Technology		ON_HOLD	On Hold	Rachel	Nathan
Kelly	R1009657	8/11/2022​	CXM	Experience & Commerce		ON_HOLD	On Hold	Rachel	Sofie
Kelly	R1006901	7/21/2022​	Functions	Global Technology		ON_HOLD	On Hold	Rachel	Gregory
Kelly	R1006909	8/8/2022​	Functions	Global Technology		ON_HOLD	On Hold	Rachel	Gregory
Kelly	R1005443	7/6/2022​	CXM	Growth		ON_HOLD	On Hold	Deborah ,Rachel	Cheridy
Kimberly	R1003107	6/16/2022​	CXM	Products		ON_HOLD	On Hold	Deborah ,Holly	Heidi
Mary	R1015123	9/30/2022​	Creative			OFFER	Open	Jennifer ,María	Bibi
Megan	R1005806	7/7/2022​	Media	Investment Mgt		INTERVIEW	Open	Rachel	Deva
Megan	R1005458	7/5/2022​	Media	Investment Mgt		SOURCING	Open	Rachel	Craig
Megan	R1005454	7/5/2022​	Media	Investment Mgt		SOURCING	Open	Rachel	Marc
Diane	R1016695	10/20/2022​				ON_HOLD	Open
Mary	REF24970M	1/19/2023​				SOURCING	Pipeline
Yvonne	REF23790P	10/4/2022​				ON_HOLD	Open
Yvonne	REF23938R	10/13/2022​				ON_HOLD	Open
Yvonne	REF23939B	10/13/2022​				ON_HOLD	Open
Yvonne	REF24217R	11/4/2022​				ON_HOLD	Open
Yvonne	REF24219K	11/4/2022​				ON_HOLD	Open
Yvonne	REF24341U	11/14/2022​				ON_HOLD	Open
Yvonne	REF24642N	12/12/2022​				ON_HOLD	Open
Gigi	R1016313	10/16/2022​				ON_HOLD	Open	Jennifer ,María	April
Diane	R1015625	10/6/2022​				CREATED	Open		Zoe
Diane	R1023717	1/19/2023​				SOURCING	Open		Bridget
Diane	R1023718	1/19/2023​				SOURCING	Open		Bridget
Gigi	R1023754	1/19/2023​				CREATED	Open		Brad
Heidi	R1023769	1/19/2023​				CREATED	Open		Rafael
Heidi	R1023749	1/19/2023​				CREATED	Open		Bridget
Jen	R1023725	1/19/2023​				CREATED	Open		Amanda
Madison	R1023763	1/19/2023​				CREATED	Open		Angela
Meagan	R1023728	1/19/2023​				SOURCING	Open		Kurt
Meagan	R1023753	1/19/2023​				SOURCING	Open		Bridget
Meagan	R1023739	1/19/2023​				SOURCING	Open		Brian
Sarah	R1023701	1/19/2023​				CREATED	Open		Emily
Sarah	R1023743	1/19/2023​				CREATED	Open		Bridget
Yvonne	REF24764J	12/24/2022​				SOURCING	Open
Yvonne	REF24896A	1/15/2023​				SOURCING	Open
Brianna	R1021992	1/11/2023​				CREATED	Open	Rachel	Tatiana
Cyndi	R1023650	1/23/2023​				SOURCING	Open	Jennifer	Jeremy
Diane	R1021736	12/21/2022​				SOURCING	Open	Jennifer	Bridget
Gigi	R1019517	11/22/2022​				SOURCING	Open	Jennifer	Felicia
Gigi	R1023761	1/19/2023​				SOURCING	Open	Deborah	Jeff
Gigi	R1023694	1/19/2023​				SOURCING	Open	Deborah	Brad
Heidi	R1022349	1/3/2023​				SOURCING	Open	Jennifer	Bridget
Kim	R1016285	10/14/2022​				SOURCING	Open	Jennifer	Pedro
Mary	R1023772	1/19/2023​				CREATED	Open	Jennifer	Justin
Meagan	R1023730	1/19/2023​				CREATED	Open	Jennifer	Bridget
Meagan	R1023733	1/19/2023​				CREATED	Open	Jennifer	Bridget
Meagan	R1023721	1/19/2023​				SOURCING	Open	Jennifer	Lee
Sarah	R1022011	1/9/2023​				SOURCING	Open	Jennifer	Kristin
Adam	R1018000	11/4/2022​	CXM	Client		INTERVIEW	Internal Hire		Anne-Marie
Amy	R1018498	11/9/2022​	CXM	Growth		INTERVIEW	External Hire		Gregory
Elizabeth	R1017797	11/3/2022​	Media	Performance Marketing		ON_HOLD	Internal Hire		Samuel
India	R1014201	10/19/2022​	Microsoft	Media Effectiveness		ON_HOLD	Open		Aaron
Kimberly	REF24063G	10/25/2022​	CXM	Marketing Tech, Data Mgt		CREATED	Pipeline
Kimberly	REF24064F	10/25/2022​	CXM	Marketing Tech, Data Mgt		CREATED	Pipeline
Laurel	REF24847A	1/10/2023​	CXM	Experience & Commerce		SOURCING	Pipeline		Natasha
Lauren	REF25017X	1/24/2023​	CXM	Marketing Tech, Data Mgt		SOURCING	Pipeline
Linda	R1020084	11/29/2022​	Media	Performance Marketing		ON_HOLD	Open		Sammie
Linda	REF23934I	10/13/2022​	Media	Performance Marketing		SOURCING	Pipeline
Linda	REF23935J	10/13/2022​	Media	Performance Marketing		SOURCING	Pipeline
Linda	REF23936W	10/13/2022​	Media	Performance Marketing		SOURCING	Pipeline
Linda	REF23937G	10/13/2022​	Media	Performance Marketing		SOURCING	Pipeline
Megan	REF24824R	1/6/2023​	Functions	HR		SOURCING	Pipeline
Megan	REF24813V	1/5/2023​	Functions	HR		SOURCING	Pipeline
Amy	R1017929	11/7/2022​	CXM	Growth		INTERVIEW	External Hire	Deborah	Owen
Amy	R1019171	11/17/2022​	CXM	Growth		INTERVIEW	External Hire	Deborah	Michel
Amy	R1021759	1/4/2023​	CXM	Experience & Commerce		OFFER	External Hire	Deborah	Tracy
Amy	R1020388	1/11/2023​	Media	Growth		INTERVIEW	External Hire	Deborah	Brian
Amy	R1023558	1/18/2023​	Media	Growth		SOURCING	External Hire	Deborah	Alexander
Amy	R1022764	1/9/2023​	CXM	Growth		SOURCING	External Hire	Deborah	Lisa
Anthony	R1016510	10/26/2022​	Functions	Finance		ON_HOLD	Open	Rachel	Philip
Cyndi	REF24823H	1/6/2023​	Creative	Growth		INTERVIEW		Jennifer
Diane	R1017505	10/31/2022​	Creative			ON_HOLD	Open	Jennifer	Zoe
Kimberly	REF23984N	10/18/2022​	CXM	Marketing Tech, Data Mgt		CREATED	Pipeline	Deborah
Kimberly	REF23985C	10/18/2022​	CXM	Marketing Tech, Data Mgt		CREATED	Pipeline	Deborah
Destiny	R1016892	10/24/2022​	CXM	Activation		SOURCING	Open
Kelly	R1022350	1/6/2023​	CXM	Transformational Consulting		SOURCING	Open
Adam	R1018737	11/11/2022​	Media	Investment Mgt		ON_HOLD	On Hold		Shannon
Adam	R1023668	1/19/2023​	Media	Investment Mgt		SOURCING	Open		Alex
Adam	R1021108	12/14/2022​	Media	Investment Mgt		SOURCING	Open		Lacey
Adam	R1017811	11/3/2022​	Media	Investment Mgt		OFFER	Open		Jennifer
Adeel	R1018735	11/11/2022​	Media	Performance Marketing		OFFER	Open		Neil
Adeel	R1020081	11/29/2022​	Media	Performance Marketing		SOURCING	Open		Eric
Adeel	R1018252	11/7/2022​	Media	Performance Marketing		OFFER	Open		Anna
Adeel	R1018254	11/7/2022​	Media	Performance Marketing		SOURCING	Open		Zi
Aleta	R1018728	11/11/2022​	Media	Media Effectiveness		INTERVIEW	Open		Andrew
Aleta	R1018730	11/11/2022​	Media	Media Effectiveness		INTERVIEW	Open		Andrew
Aleta	R1020835	12/8/2022​	Media	Media Effectiveness		SOURCING	Open		Julia
Aleta	R1017794	11/3/2022​	Media	Media Effectiveness		ON_HOLD	On Hold		Sharon
Aleta	R1020658	12/6/2022​	Media	Media Effectiveness		SOURCING	Open		Sharon
Aleta	R1019516	11/22/2022​	Media	Media Effectiveness		ON_HOLD	On Hold		Brian
Aleta	R1020664	12/6/2022​	Media	Media Effectiveness		SOURCING	Open		Ivan
Aleta	R1020082	11/29/2022​	Media	Media Effectiveness		INTERVIEW	Open		Tara
Aleta	R1021459	12/16/2022​	Media	Media Effectiveness		OFFER	Open		Connor
Alexander	R1020075	11/29/2022​	Media	Investment Mgt		ON_HOLD	On Hold		Michael
Alexander	R1023816	1/20/2023​	Media	Investment Mgt		SOURCING	Open		Lauren
Alexander	R1018633	11/11/2022​	Media	Investment Mgt		ON_HOLD	On Hold		Megan
Alexander	R1018247	11/7/2022​	Media	Investment Mgt		SOURCING	Open		Rosalind
Alexander	R1021751	12/21/2022​	Media	Investment Mgt		SOURCING	Open		Karly
Alexander	R1022471	1/5/2023​	Media	Investment Mgt		SOURCING	Open		Shan
Anabel	R1020819	12/8/2022​	Media	Investment Mgt		SOURCING	Open		Craig
Anabel	R1020837	12/8/2022​	Media	Investment Mgt		SOURCING	Open		Craig
Anabel	R1022466	1/4/2023​	Media	Investment Mgt		SOURCING	Open		Claudia
Anabel	R1017790	11/3/2022​	Media	Investment Mgt		ON_HOLD	On Hold		Sally
Anabel	R1020912	12/9/2022​	Media	Investment Mgt		INTERVIEW	Open		Mindy
Arielle	R1022791	1/9/2023​	CXM	Activation		ON_HOLD	On Hold		Christy
Arielle	R1022792	1/9/2023​	CXM	Activation		ON_HOLD	On Hold		Christy
Arielle	R1020914	12/13/2022​	CXM	Activation		SOURCING	Open		Christy
Ashley	R1019344	12/8/2022​	MKTG Sports/DSI			OFFER	Open		Aidan
Ashley	R1016783	10/24/2022​	MKTG Sports/DSI			SOURCING	Open		Dominic
Ashley	R1023577	1/21/2023​	MKTG Sports/DSI			OFFER	Open		James
Ashley	R1023546	1/21/2023​	MKTG Sports/DSI			SOURCING	Open		Tina
Chavon	R1017122	11/4/2022​	CXM	Experience & Commerce		OFFER	Open		Derek
Chavon	R1017125	11/4/2022​	CXM	Experience & Commerce		INTERVIEW	Open		Derek
Chavon	R1021581	12/26/2022​	CXM	Experience & Commerce		OFFER	Open		Derek
Chris	R1021444	12/16/2022​	CXM	Solutions, B2B		SOURCING	Open		Georgia
Chris	R1021447	12/16/2022​	CXM	Solutions, B2B		SOURCING	Open		Georgia
Chris	R1021448	12/16/2022​	CXM	Solutions, B2B		SOURCING	Open		Georgia
Corinna	REF24115A	11/1/2022​	Creative			SOURCING	Open
Elizabeth	R1022453	1/4/2023​	Media	Performance Marketing		SOURCING	Open		Noel
Elizabeth	R1019126	11/17/2022​	Media	Performance Marketing		SOURCING	Open		Amanda
Emily	R1020068	11/29/2022​	Media	Investment Mgt		OFFER	Open		Julie
Emily	R1022461	1/4/2023​	Media	Investment Mgt		ON_HOLD	On Hold		Ryan
Emily	R1018732	11/11/2022​	Media	Investment Mgt		OFFER	Open		Michelle
Emily	R1017808	11/3/2022​	Media	Investment Mgt		ON_HOLD	On Hold		Ryan
Emily	R1018246	11/7/2022​	Media	Investment Mgt		OFFER	Open		Ariel
Emily	R1019522	11/22/2022​	Media	Investment Mgt		ON_HOLD	On Hold		Avalon
Emily	R1020074	11/29/2022​	Media	Investment Mgt		ON_HOLD	On Hold		Nicole
Emily	R1015416	10/4/2022​	Media	Investment Mgt		ON_HOLD	On Hold		Mariya
Emily	R1017813	11/3/2022​	Media	Investment Mgt		ON_HOLD	On Hold		Ankita
Grace	R1020657	12/6/2022​	Media	Media Effectiveness		SOURCING	Open		Sharon
Grace	R1019133	11/18/2022​	Media	Media Effectiveness		SOURCING	Open		Adil
Grace	R1013949	10/12/2022​	Microsoft	Performance Marketing		INTERVIEW	Open		Michael
India	R1017123	10/25/2022​	Media	Performance Marketing		SOURCING	Open		Victoria
Jaylis	R1016895	11/23/2022​	Creative	Strategy & Insights		OFFER	Open		Katie
Jen	R1021887	12/21/2022​	CXM	Experience & Commerce		INTERVIEW	Open		Patrick
Jen	R1022034	12/23/2022​	CXM	Experience & Commerce		SOURCING	Open		Patrick
Jen	R1022035	12/23/2022​	CXM	Experience & Commerce		SOURCING	Open		Patrick
Jenna	R1022953	1/11/2023​	Media	Investment Mgt		SOURCING	Open		Salvatore
Jenny	R1017124	10/25/2022​	CXM	Experience & Commerce		INTERVIEW	Open		Derek
Jessica	R1019485	11/22/2022​	Media	Investment Mgt		SOURCING	Open		James
Jessica	R1023070	1/12/2023​	Media	Investment Mgt		SOURCING	Open		James
Jessica	R1016903	10/21/2022​	Media	Investment Mgt		SOURCING	Open		Bailey
Joey	R1021627	12/21/2022​	Media	Investment Mgt		SOURCING	Open		Emiliya
Joey	R1022545	1/5/2023​	Media	Investment Mgt		INTERVIEW	Open		Matthew
Jordan	R1023741	1/19/2023​	Creative	Client		SOURCING	Open		Joshua
Jordan	R1023775	1/19/2023​	Creative	Client		SOURCING	Open		Kristin
Jordan	R1023727	1/19/2023​	Creative	Client		SOURCING	Open		Eleanor
Kelly	R1021456	1/11/2023​	Functions	HR		SOURCING	Open		Antoinette
Kevin	R1019241	11/18/2022​	Media	Media Effectiveness		SOURCING	Open		James
Kevin	R1020076	11/29/2022​	Media	Media Effectiveness		ON_HOLD	On Hold		Elizabeth
Kevin	R1020078	11/29/2022​	Media	Media Effectiveness		ON_HOLD	On Hold		Elizabeth
Kimberly	R1019958	11/28/2022​	CXM	Marketing Tech, Data Mgt		INTERVIEW	Open		Anne
Lara	R1016001	10/31/2022​	Microsoft	Media Effectiveness		SOURCING	Open		Maya
Lara	R1020046	11/29/2022​	Microsoft	Media Effectiveness		INTERVIEW	Open		Caroline
Lara	R1014078	10/19/2022​	Microsoft	Media Effectiveness		SOURCING	Open		William
Lara	R1017792	11/4/2022​	Microsoft	Performance Marketing		INTERVIEW	Open		Sylwia
Laurel	R1021760	1/3/2023​	CXM	Experience & Commerce		INTERVIEW	Open		Eric
Laurel	R1019954	11/28/2022​	CXM	Marketing Tech, Data Mgt		SOURCING	Open		Craig
Laurel	R1019956	11/28/2022​	CXM	Marketing Tech, Data Mgt		SOURCING	Open		Craig
Laurel	R1019957	11/28/2022​	CXM	Marketing Tech, Data Mgt		SOURCING	Open		Craig
Laurel	R1020990	1/5/2023​	Functions	Operations		CREATED	Open		Monica
Lauren	R1021540	1/11/2023​	Functions	Global Technology		INTERVIEW	Open		Calvin
Lauren	R1022469	1/17/2023​	Functions	Global Technology		SOURCING	Open		Calvin
Madison	R1023736	1/19/2023​	Creative	Client		CREATED	Open		Alexander
Madison	R1018389	11/9/2022​	Creative	Client		SOURCING	Open		Stephanie
Madison	R1021537	12/16/2022​	Creative	Client		SOURCING	Open		Christopher
Madison	R1021776	12/21/2022​	Creative	Client		SOURCING	Open		Christopher
Madison	R1021779	12/21/2022​	Creative	Client		SOURCING	Open		Christopher
Madison	R1023715	1/19/2023​	Creative	Client		CREATED	Open		Eric
Mary	R1020284	12/1/2022​	CXM	Experience & Commerce		SOURCING	Open		Alexander
Nicole	R1019239	11/18/2022​	CXM	Experience & Commerce		SOURCING	Open		David
Nikki	R1021538	1/7/2023​	Creative			OFFER	Open		Katie
Rain	R1020904	12/13/2022​	Creative	Brand & Experience		INTERVIEW	Open	Jennifer
Adam	R1015133	10/3/2022​	CXM	Experience & Commerce		OFFER	Open	Deborah	Jason
Adam	R1020300	12/2/2022​	CXM	Analytics		SOURCING	Open	Chelle	Nathan
Adam	R1021745	12/21/2022​	CXM	Client		INTERVIEW	Open	Deborah	Jeannette
Aleta	R1020834	12/8/2022​	Media	Media Effectiveness		OFFER	Open	Deborah	Julia
Aleta	R1023567	1/18/2023​	Media	Media Effectiveness		OFFER	Open	Deborah	Isabel
Amanda	R1020085	12/15/2022​	Functions	Global Technology		ON_HOLD	On Hold	Rachel	Pradeep
Amanda	R1017325	10/27/2022​	Functions	Technology		INTERVIEW	Open	Rachel	John
Tracie	R1017593	11/4/2022​	Functions	Finance		INTERVIEW	Open	Rachel	Michael
Tracie	R1019049	11/18/2022​	Functions	Finance		SOURCING	Open	Rachel	Kristy

Will this snippet of data do? It would be amazing if you could help me with creating a macro to automatically format the cells as they correspond to the criteria I listed in a previous post. I had to hide some columns so they don't match up exactly to the criteria - will it be close enough? After the cells have been correctly formatted, then need a macro to count the rows that contain any highlighted cells. Essentially, those cells contain errors so I want to count how many rows with errors there are.

 

[awoohaw]

yes, it will work great. But, it is a swappit, not a snippit!

 

[Rick Rothstein]

Essentially, those cells contain errors so I want to count how many rows with errors there are.

Let's concentrate on that last statement... what do you mean by "essentially"?

Are there highlighted cells other than those with errors that you also want to count?

Also, can there be more than one error on a single row?