Change color in cell based on range of values, and change the color of same cell based on value in another range once that's entered.

[nscaria00]

Hi, I need help as I am totally new to VBA.
I have an excel document that's like a dashboard. I have Column 'N' for EO status'. User enters information in rows from A6 to E6 (same way for each rows). When someone enters infomartion, then Column 'N against that row needs to turn RED. Once Management signs off, which is in column 'F to M', then Column 'N' against that row needs to turn to Green.
Can you please help developing a code.

 

[awoohaw]

Also, you have merged cells. these really mess up folks trying to work with your data.

 

[awoohaw]

QUESTION: You did not say that columns F to N may contain formulas, you just said a 'sign off' which to me meant that someone will TYPE data into a blank cell. The conditional formatting counts non blank cells.

 

[awoohaw]

Okay, I think this will work for you:

mr excel questions 25.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
10
11													Completion Date
12						Accounting	Purchasing	Customer Service	Quality	Engineering	Production	Final Signoff		EO Status
13	EO #	Initiator	Date	Part #	Change Description	Pat	Mat	Leah		David	Anish	Anil	2023-03-27
14	23-Feb	adam	2023-04-28	6655	545	Pat	Mat	Leah	George	David	Anish	Anil	2023-04-28	EO 23-02	TRUE	TRUE
15	23-Feb	adam	2023-04-28	6655	545	Pat	Mat	Leah		David	Anish	Anil	2023-04-28	EO 23-02	TRUE	FALSE
16	23-Mar	adam	2023-04-28	152	3541									EO 23-03	TRUE	FALSE
17															FALSE	FALSE
18															FALSE	FALSE
nscaria00

Cell Formulas
Range	Formula
O14:O18	O14	=SUM(--($A14:$E14<>""))>1
P14:P18	P14	=SUM(--($F14:$N14<>""))=COLUMNS(F$14:N$14)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
N14:N18	Expression	=SUM(--($F14:$N14<>""))=COLUMNS(F$14:N$14)	text	NO
N14:N18	Expression	=SUM(--($A14:$E14<>""))>1	text	NO

 

[nscaria00]

Let me try. Thank you!