Conditional Formatting based on multiple criterions.

[mynameisjeff]

Ok, so I need to highlight one cell based on a lot of different criterions.

https://www.dropbox.com/s/w2scs59ip464kvm/EXAMPLE 1.xlsx?dl=0

I hope this example workbook can explain it better.

 

[etaf]

we can use conditional formatting rules
so for orange paid - all we need to do is look at cell in column E to see if it has "paid" = YES
and for yellow

is it simply date out = TBD ?

and so green would be NOT TBD in the date out

Not sure how you enter dates and how today() matters if the above are correct

anyways heres the spreadsheet
https://www.dropbox.com/s/fy6pv8s2lksl4bf/EXAMPLE 1 etaf.xlsx?dl=0

i have also changed the Green to not include blank cells with an AND
Also put them in a specific order and stop if true so one rule does not overide a previous true

see next post for spreadsheet embeded

 

[etaf]

Excel Workbook
	A	B	C	D	E
1	TODAY	RO #	Date IN	Date OUT	PAID
2	22/09/2017	1111	23/09/2017	TBD	NO
3	24/09/2017	2222	23/09/2017	24/09/2017	NO
4	24/09/2017	3333	23/09/2017	24/09/2017	YES
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B1	1. / Formula is =E1="yes"	Abc
B1	2. / Formula is =D1="TBD"	Abc
B1	3. / Formula is =AND(D1<>"TBD", D1<>"")	Abc
B2	1. / Formula is =E1="yes"	Abc
B2	2. / Formula is =D1="TBD"	Abc
B2	3. / Formula is =AND(D1<>"TBD", D1<>"")	Abc
B3	1. / Formula is =E1="yes"	Abc
B3	2. / Formula is =D1="TBD"	Abc
B3	3. / Formula is =AND(D1<>"TBD", D1<>"")	Abc
B4	1. / Formula is =E1="yes"	Abc
B4	2. / Formula is =D1="TBD"	Abc
B4	3. / Formula is =AND(D1<>"TBD", D1<>"")	Abc