Conditional formatting with a difference

Hi, I'm stuck!

I am creating a tracker and am trying to use conditional formatting to highlight a relevant cell based on performance

I have a simple 4X4 grid that has we measure volume (25%, 30%, 40%, 50%)and value (25%, 30%,40%, 50%) performance
then the idea is that when someone hits for example 25% volume, and 40% value (both calculated in separate tables) ,it would highlight the relevant cell in the above chart

Really not sure how to get this right

TIA

I'm sure it can be done but we need a file with some sample entries

Noted:

In the sample attached I have 4 clients with a value of £25,000 (E12 and 13)
I have contacted 2 of the above clients with a value of £16920 combined (Row 14 and below, counted and summed in A2 and A3)
This is then converted as a percentage of what I had/Have available and displayed in E2 and E3

In the sample, I can see that because I have hit 50% Volume and 68% Value, I am awarded the payment in E6, This is the cell I need to be highlighted in Green, or have a heavy lined border.
As I contact more clients I would like the applicable cell to be highlighted.

Hope that makes sense and apologies for the confusion with no sample earlier.

Al

Hi John, thanks for this.
I've applied the formula and it highlighted 2 cells which threw me slightly, I've expanded the selection to pull in the full table but it still does the same.
Interestingly, if i copy the formula into blank cell, and drag across to get 4 up 4 across as per the main table, I can see that the formula IS working as it only returns TRUE on the corresponding cell, but how do i get this into the main table and get it to highlight the only cell that corresponds to the correct mix?

Al

Gents, thank you. sorted!

Hi Hero

I first increased the references in cells A1 and A2 to include the rest of the columns mentioned so I could add data.
Cell A1

Please Login or Register  to view this content.

Cell A2

Please Login or Register  to view this content.

conditional formatting (home tab, Conditional formatting)
Cell E6

Please Login or Register  to view this content.

and I copied it to E6:E9.

I'm not sure what the percentages are cells B5:E5
The way I read it is that is the percentage of contacted clients? if so the I thought you would be due payment as Cell B6.

I have only formulated E6:E9
and each cell highlights as you get to it. or did you want just the cell you are due to be highlighted. (I tried to format with a thick border but you can only format upto the thin border, same as you already have)

Hello again.
I don't know what it is I'm not understanding about this but I'm now trying to apply this same logic to a different (but very similar) sheet but cannot get my formula to work at all

I'm applying this
=AND($I$8>=B$9,$I$8<=C$9,$I$9>=$C8,$I$9<=$C9)
to the cells D3:G12

The desired result is that the relevant cell from teh selection is highlighted based on the values in I8 and I9

In the attached example cell F12 would be highlighted.

I then need to apply this to each table on the sheet

thanks wildecoyote1966

Cheers John