Conditional formatting few cells when the records meet certain number requirements/range.

Can be done without VBA.

Your manually entered results are not quite correct, however:

1. Select cell D2.
2. Create a conditional formatting formula rule using this formula:

$B2>=INDEX($I$3:$J$15,MATCH(D2,$H$3:$H$15,0),MATCH($C2,$I$2:$J$2,0))

3. Set the formatting required.
4. In the Applies To box, type:

=$D$2:$F$6

All done.

There is nothing wrong with the attachment - it opens fine. If you are having problems implementing the CF rule, then attach YOUR file here for me to have a look at.

You have speech marks at either end of the formula:

="$B2>=INDEX($I$3:$J$15,MATCH(D2,$H$3:$H$15,0),MATCH($C2,$I$2:$J$2,0))"

They should not be there - get rid of them.

it works now. Appreciate your time and patience. I dont know why that speech marks appeared anyway.
Would you be able to explain the logic of the formula in simple terms. I'm trying to graps...why = B2, why index, why match, why ,0.....etc.)

OK. Here we go:

=$B2>=

1. Check if B2 is bigger than or equal to ...

INDEX($I$3:$J$15,

2. ... the value found in the range I3:J5 ...

MATCH(D2,$H$3:$H$15,0),

3. ... that matches the intersection in the lookup table of the contents of D2 (found in column H of the lookup table) ...

MATCH($C2,$I$2:$J$2,0))

4. ... and the contents of C2 (found in I2:J2 of the lookup table.

Basically it's a lookup.