Conditional formating.

[Patb3]

I need a formula to accomplish the following.: If b5=D17 or F17 , then E17 =0% if b5=D18 or F18,then E18=38%. If b5 =D19 or F19, then E19=55% etc for 13 different values.

 

[Toadstool]

Hi Patb3,

Without knowing how the percentage is calculated then all I can provide is a column of values to be selected.

Book2
	B	C	D	E	F	G	H
5	77
16
17			5		7		0
18			59		61		38
19			116		118		55
20			176		178		77
21			77	62%	77		62
22			143		143		2
23			212		212		4
24			77	9%	284		9
25			152		359		26
26			230	87%	77		87
27			311		158		88
28			395		242		44
29			77	25%	329		25
Sheet1

Cell Formulas
Range	Formula
E17:E29	E17	=IF(OR($B$5=D17,$B$5=F17),H17%,"")

 

[Peter_SSs]

Welcome to the MrExcel board!

I need a formula to accomplish the following.: If b5=D17 or F17 , then E17 =0% if b5=D18 or F18,then E18=38%. If b5 =D19 or F19, then E19=55% etc for 13 different values.

This sounds like you want a value displayed somewhere in column E depending on the values in columns D & F.
What, if anything, does it have to do with Conditional Formatting which is the title of your thread?

Can you use XL2BB to give us some sample data and expected results and explain further in relation to that sample data?