Filter criteria in reference cells

G

Go Bucks!!!

I was trying to do conditional formatting by filtering on the customer
(column E) and applying my conditional formating to those cells. It didnt
work. Can I do conditional formatting based matching the customer and
criteria?


My data is as follows:

E I
1 Toshiba 95%
2 Intel 92%
3 Samsung 89%

Performance Targets:
L M
1 Toshiba >=95%
2 Intel >=90%
3 Samsung >=90%

The conditional formating formulas are currently...

AND(I2<>"",I2>=0.95)
Condition is green

AND(I2<>"",I2<0.95)
Condition is red

Thanks,
 
G

Go Bucks!!!

Great, thank you.

I created a reference table with my criteria. This is how my formula ended
up...

=OR(AND(I2<>"",E2=$K$5,I2>=$O$5),AND(I2<>"",E2=$K$6,I2>=$O$6),AND(I2<>"",E2=$K$7,I2>=$O$7),AND(I2<>"",E2=$K$8,I2>=$O$8),AND(I2<>"",E2=$K$9,I2>=$O$9),AND(I2<>"",E2=$K$10,I2>=$O$10))

Where: I:I are the results, E:E is the customer and O:O are the criteria,
e.g. 95.

Works great!
 
D

Dave Peterson

Better to stay in the original thread.
I was trying to do conditional formatting by filtering on the customer
(column E) and applying my conditional formating to those cells. It didnt
work. Can I do conditional formatting based matching the customer and
criteria?

My data is as follows:

E I
1 Toshiba 95%
2 Intel 92%
3 Samsung 89%

Performance Targets:
L M
1 Toshiba >=95%
2 Intel >=90%
3 Samsung >=90%

The conditional formating formulas are currently...

AND(I2<>"",I2>=0.95)
Condition is green

AND(I2<>"",I2<0.95)
Condition is red

Thanks,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top