Help with Conditional Formatting please!

[BJSinger7623]

Ok, maybe I'm trying to do too many. LOL

I currently have conditional formatting on for if Column A says OPEN, the row turns red, if Column I says TERM it turns grey. I need to add (and I've tried, but it isn't working) if Column I says PENDING it turns green. Is that possible or is that just too much formatting for one column?

Thank you!

CROW, MICHAEL	4/2/2021	SCHEDULE	L2S1	TEMP	AS	35	ACTIVE
CUATT, REGINA	4/14/2021	SCHEDULE	L2S1	TEMP	AS	23	TERM
DENT, KEONDRE	5/5/2021	3:15 PM	L2S1	DIRECT	VS	2	ACTIVE
DEWITT, DANYEAL	4/29/2021	3:00 AM	SHIP	TEMP	AS	8	ACTIVE
DOMINIAK, ROGER	4/28/2021	3:15 PM	L2S1	DIRECT	VS	9	ACTIVE
DORRANCE, BRYAN	5/3/2021	5:00 AM	L4S1	TEMP	VS	4	ACTIVE
EATMAN, CHRISTOPHER	2/20/2021	SCHEDULE	L2S2	TEMP	VS	76	ACTIVE
FALCON, CHRISTOPHER	4/21/2021	SCHEDULE	L2S2	TEMP	AS	16	ACTIVE
FOLLOWELL, SEAN	4/29/2021	3:15 PM	L2S1	TEMP	VS	8	ACTIVE
HAMILTON, LINDA	4/29/2021	1:15 AM	L2S2	TEMP	VS	8	ACTIVE
HATFIELD, AMY	4/14/2021	SCHEDULE	L4S1	TEMP	VS	23	ACTIVE
HAZZARD STACY	4/23/2021	SCHEDULE	L1S1	TEMP	VS	14	ACTIVE
HILL, SKYLER	4/19/2021	SCHEDULE	L1S1	TEMP	VS	18	ACTIVE
HOLT, MARGARET	3/9/2021	SCHEDULE	L4S1	TEMP	AS	59	ACTIVE
HOUT, TIMOTHY	3/9/2021	SCHEDULE	SHIP	TEMP	AS	59	ACTIVE
HOWDER, PARKER	4/29/2021	2:00 PM	SHIP	TEMP	VS	8	ACTIVE
HOWDER, STEPHANIE		8:00 AM	SANI	DIRECT		44323	ACTIVE
JEAN, ELLIE	5/3/2021	3:15 PM	L2S1	TEMP	VS	4	ACTIVE
LIVINGSTON, BRYAN	5/7/2021	3:15 PM	L2S1	TEMP	VS	0	PENDING
LOVELESS, ERIC	5/4/2021	3:15 PM	L2S1	TEMP	VS	3	ACTIVE
MILLER, MARK	4/23/2021	SCHEDULE	L2S2	TEMP	VS	14	ACTIVE
MILLER, MATTHEW	4/21/2021	SCHEDULE	L2S2	TEMP	AS	16	ACTIVE
MORALES, RONY	4/6/2021	SCHEDULE	L1S1	TEMP	VS	31	ACTIVE
OPEN		4:30 AM	L1S1			44323
OPEN		3:15 PM	L2S1			44323
OPEN		3:15 PM	L2S1			44323
OPEN		3:15 PM	L2S1			44323

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H
1
2	CROW, MICHAEL	04/02/2021	SCHEDULE	L2S1	TEMP	AS	35	ACTIVE
3	CUATT, REGINA	4/14/2021	SCHEDULE	L2S1	TEMP	AS	23	TERM
4	DENT, KEONDRE	05/05/2021	3:15 PM	L2S1	DIRECT	VS	2	ACTIVE
5	DEWITT, DANYEAL	4/29/2021	3:00 AM	SHIP	TEMP	AS	8	ACTIVE
6	DOMINIAK, ROGER	4/28/2021	3:15 PM	L2S1	DIRECT	VS	9	ACTIVE
7	DORRANCE, BRYAN	05/03/2021	5:00 AM	L4S1	TEMP	VS	4	ACTIVE
8	EATMAN, CHRISTOPHER	2/20/2021	SCHEDULE	L2S2	TEMP	VS	76	ACTIVE
9	FALCON, CHRISTOPHER	4/21/2021	SCHEDULE	L2S2	TEMP	AS	16	ACTIVE
10	FOLLOWELL, SEAN	4/29/2021	3:15 PM	L2S1	TEMP	VS	8	ACTIVE
11	HAMILTON, LINDA	4/29/2021	1:15 AM	L2S2	TEMP	VS	8	ACTIVE
12	HATFIELD, AMY	4/14/2021	SCHEDULE	L4S1	TEMP	VS	23	ACTIVE
13	HAZZARD STACY	4/23/2021	SCHEDULE	L1S1	TEMP	VS	14	ACTIVE
14	HILL, SKYLER	4/19/2021	SCHEDULE	L1S1	TEMP	VS	18	ACTIVE
15	HOLT, MARGARET	03/09/2021	SCHEDULE	L4S1	TEMP	AS	59	ACTIVE
16	HOUT, TIMOTHY	03/09/2021	SCHEDULE	SHIP	TEMP	AS	59	ACTIVE
17	HOWDER, PARKER	4/29/2021	2:00 PM	SHIP	TEMP	VS	8	ACTIVE
18	HOWDER, STEPHANIE		8:00 AM	SANI	DIRECT		44323	ACTIVE
19	JEAN, ELLIE	05/03/2021	3:15 PM	L2S1	TEMP	VS	4	ACTIVE
20	LIVINGSTON, BRYAN	05/07/2021	3:15 PM	L2S1	TEMP	VS	0	PENDING
21	LOVELESS, ERIC	05/04/2021	3:15 PM	L2S1	TEMP	VS	3	ACTIVE
22	MILLER, MARK	4/23/2021	SCHEDULE	L2S2	TEMP	VS	14	ACTIVE
23	MILLER, MATTHEW	4/21/2021	SCHEDULE	L2S2	TEMP	AS	16	ACTIVE
24	MORALES, RONY	04/06/2021	SCHEDULE	L1S1	TEMP	VS	31	ACTIVE
25	OPEN		4:30 AM	L1S1			44323
26	OPEN		3:15 PM	L2S1			44323
27	OPEN		3:15 PM	L2S1			44323
28	OPEN		3:15 PM	L2S1			44323
29
Lists

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:H29	Expression	=$H2="Pending"	text	NO
A2:H29	Expression	=$H2="term"	text	NO
A2:H29	Expression	=$A2="Open"	text	NO

 

[BJSinger7623]

Tried...doesn't work. When I change them to TERM it still grey's out, but when I put them to PENDING there's no color

 

[BJSinger7623]

When I pull up the rules (to manage) it shows the grey and red for all cells in multiple lines, but when I add in the green it only shows it one time:

 

[Fluff]

You appear to be setting the rules for individual rows, rather than the complete area like I showed.

 

[BJSinger7623]

Any chance you can hold my hand and kiddie walk me through please???

 

[Fluff]

Delete all your rules then select the range you want the rules to work on, say A2:I40 then in conditional formatting apply the rules where the formula looks at the first row in the applies to range.

 

[BJSinger7623]

Ok, you're amazing!!! Thank you SO much!!! It's PERFECT now and I now I understand what I did wrong!!! Thank you!!!

 

[Fluff]

You're welcome & thanks for the feedback.