Conditional Formatting where Matrix intersects


R

Rebecca_SUNY

I have a matrix (see below) and would like to format the row yellow and the
column red and where they INTERSECT orange. I am able to get the row and
column formatting to work but the intersection formula will not.

apple banana grapes
red 34 21 -
pink 20 22 -
black - - 12

Assuming I pick pink/banana, the 3rd row would be yellow, the 3rd column
would be red and the value in cell C3 (22) would be orange.

This is what I have right now for the intersection conditional formatting
"formula is" (assuming the full table is selected)

=IF(AND($A1="pink",A$1="banana"),,)

If only cell C3 is selected it would be

=IF(AND($A3="pink",C$1="banana"),,)

But it will not work. :(

Thanks for your help in advance.
 
Ad

Advertisements

L

~L

You don't need the IF( ,,) parts.

Take that out, and you should be gold. Or blue, red, or whatever color you
choose to fill with.
 
Ad

Advertisements

R

Rebecca_SUNY

I took the IF out and it still didn't work. I had to change the order of the
conditions so that the intersection was FIRST and then the row and column
formatting were second and third. Then is worked like a charm.

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

Similar Threads


Top