Conditional formatting based upon two cell's data

[theavenger001]

Hello, I'm just diving into the world of conditional formatting.

I am comparing the speeds of different brands of SD cards. I want to highlight those that have a speed above the acceptable range green, and those below the acceptable range red.
However, the different brands and different tests will have different range limits.

For example, I want it to look at column D, if it has the text "Samsung" then it looks at column M and if the value is greater than 7300 it highlights the cell green, it it's below 7300 then it highlights it red. If the cell in column D has the text "SanDisk", then I want the range for column M to be greater than 6000 = green highlight, less than 6000 = red highlight, etc.

I'm hoping to do this highlighting for all the parameters I am testing (columns I, J, K, L, M, N).

I think I just need a fairly simple equation that I tweak for each column/manufacturer/highlight colour, but I'm not sure?

Any help would be greatly appreciated.

Thanks

[etaf]

best way maybe to have a sheet with the manufacturer and the speed & other values and and then lookup the value and compare

=$M2>INDEX(Sheet2!$B:$B,MATCH($D2,Sheet2!$A:$A,0))
for green
You could then just have a normal fill of red
For the column , then the conditional formatting will overwrite with Green

[theavenger001]

Yes, that works! Thank you very much!

[etaf]

you are welcome