Need Filter by color

[Techtrend]

Need Filter by color,
Attached is the doc in which yellow marked Row for which the Data is required,

Have clearly mentioned in the document for the formula required,
Required shorting on BUY and sell based on the color.

Narendra

 

[Deepak]

Check this.

=IF(AND(D2=F2,B2>=G2),"BUY",IF(AND(D2=E2,B2<=H2),"SELL",""))

 

[Techtrend]

Hello Deepak

I am looking the if conditions based the Color of the Column and just not higher and lower values.

Can you please tell me if we have F and G Col is Green ,then in I Col we then need to display BUY ,

Can you please fix and update Accordingly.

Thanks for your efforts
Narendra

 

[ThrottleWorks]

Hi @Techtrend ,meanwhile @Deepak Sir helps you, could you please check the below.

Enter below mentioned Function in a module.

Function MyColor(Arg1 As Range) As Long
MyColor = Arg1.Interior.ColorIndex
End Function

Range I2 formula = MyColor(F2)
Range J2 formula = MyColor(G2)
Range K2 formula = IF(I2+J2=86,"Buy",IF(I2+J2=6,"Sell"))

 

[Deepak]

Hello Deepak

I am looking the if conditions based the Color of the Column and just not higher and lower values.

Can you please tell me if we have F and G Col is Green ,then in I Col we then need to display BUY ,

Can you please fix and update Accordingly.

Thanks for your efforts
Narendra

What i have shared based on the condition you specified and CF which is base for color change & same is still working without any issue may i have the expected output in col I.

 

[Techtrend]

Hi

I have simplified the sheet,
The match has to be done based only on color as reference only,
I am using the same on a live sheet on which VBA is Not supporting.

 

[Nebu]

Hi:

Find the attached.

Thanks

 

[Techtrend]

Thanks A LOT

 

[Nebu]

Hi:

I was playing around a bit for fun, If you could give the following formula in the name range I guess you do not have to format Column E

=GET.CELL(63,OFFSET(INDIRECT("C"&ROW()),,1,2))

Thanks