yogi_Conditional Formatting For Multiple Ranges For A Combination Of AND OR Conditions Using Google New Sheets


1
2	BB	Beautify Brookfield
3	BBC	Brookfield Beautification Commission
4	DPW	Department of Public Works
5	Option 1
6	Option 2
7	Option 3
8	Option 4
9	N/A	Used when budget is based on milestone

Published by Google Sheets–Report Abuse–Updated automatically every 5 minutes


1	Project 2014
2	Project Lead:
3					Planned					Actual
4	ID	Deliverable Name/Task Name	Assigned To	Done	Duration (Days)	Start	End	Cost	Funded By	Duration (Days)	Start	End	Cost	Funded By

5	1	General Organization - Prior to Event			60	1/1/2014	3/1/2014	$0.00	N/A	97	11/12/2013	2/19/2014	$0.00	N/A
6	1.1	Task 1	CCC	x	0	1/14/2014	1/14/2014			0	11/12/2013	11/12/2013
7	1.1.1	Sub Task	DPW		30	1/1/2014	1/31/2014			-41086	2/16/2014
8	1.2	Task w	BRE		60	1/1/2014	3/1/2014			-41086	2/16/2014
9	1.3	Task 3		x	48	1/1/2014	2/19/2014			-41087	2/17/2014
10	1.4	Task 4			48	1/1/2014	2/19/2014			2	2/17/2014	2/19/2014
11					0					0
12
13
14
15
16


1
2	CONDITIONAL FORMATTING FOR RANGES B6:B, AND D6:D
3	if cell in column D="" or column L="", and date in cell of column H < today(), and cell of column B<>""
4	Custom formula is:	=AND(OR($M6="",$E6=""),TODAY()>$H6,$H6<>"")
5
6
7
8
9
10
11
12
13
14