CONDITIONAL FORMATING FOR CELL COLOUR AS PER VALUE LOWEST 1, LOWEST 2 & LOWEST 3

[DEEPAK UBHE]

Need help to formatting the cell as per their value in the series as lowest-1, lowest-2 & lowest 3
for example
A1=500, C1=400, E1=800, G1=350, I1=700
conditional formatting will be as below

• being G1 is Lowest1 = Cell Color will be Green
• being C1 is Lowest2 = Cell Color will be Yellow
• being A1 is Lowest1 = Cell Color will be Pink
• and E1 & I1 are not in range of L1 to L3 will not be formatted with any colour

 

[12Rev79]

may be like this:

from your examples write your values in the cell A1=500, C1=400, E1=800, G1=350, I1=700

and copy paste this formula across cell A2:I2
=IF(C1="","",IF(C1<400,"G",IF(C1=400,"Y",IF(AND(C1>400,C1<=500),"P",""))))

Select G1 and select Conditional Formatting>Manage rules>New Rules>Use a formula to determine which format a cells

paste the formula
=G2="G"

copy paste the formatting to another cells and edit the color

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I
1	500	400	400		800	200	350		700
2	600		300	1	250	8	500		89
3
Main

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:I3	Expression	=AND(A1=AGGREGATE(15,6,$A1:$I1/(ISODD(COLUMN($A1:$I1)))/($A1:$I1<>""),3),ISODD(COLUMN(A1)))	text	NO
A1:I3	Expression	=AND(A1=AGGREGATE(15,6,$A1:$I1/(ISODD(COLUMN($A1:$I1)))/($A1:$I1<>""),2),ISODD(COLUMN(A1)))	text	NO
A1:I3	Expression	=AND(A1=AGGREGATE(15,6,$A1:$I1/(ISODD(COLUMN($A1:$I1)))/($A1:$I1<>""),1),ISODD(COLUMN(A1)))	text	NO