Need conditional formatting to highlight if greater than a cell but not highlight if less

[mma3824]

I would like conditional formatting to highlight when column C quantity is greater than K15, but if it is less than or equal to K15 I don't want column C to highlight.

[mikeava]

Try this. Please let me know if you have any questions.

[mma3824]

Did you put in a formula? It seems to be working but I cant find what you put in?

[mma3824]

Did you put in a formula? It seems to be working but I cant find what you put in?

[mikeava]

I used Conditional Formatting.

I highlighted C15 to C24
Then on Home Tab - I clicked on Conditional Formatting.
Highlight Cell Rules
Greater Than
In the box (should say 100 I think) I just clicked your cell K15 and the value changes to =$K$15
In the box next to with - you can pick any selection there. I just used Custom and changed the formatting there.

If you click on Conditional Formatting and Manage rules you will see what it looks like.

[mma3824]

Ok so I had the conditional formatting working for this and then we had to make some changes and now I cannot get the conditional formatting to work again. We have a formula to get the current inventory from the field inventory sheet so if we do not have that part in the current inventory it says zero. However we need it to highlight if the qty is greater than the current inventory.

[Glenn Kennedy]

If you have changed something, the original sample sheet may no longer be relevant. Please add an appropriate sample sheet.

[mma3824]

Glenn,
I have the most recent example with the changes in my last comment.
Thanks

[Glenn Kennedy]

The reason it isn't working is becausew the SLOC for Part Number 1726 is 9, not 1. Your formula in H is very inefficient because you are using whole column references in an array formula. There was also an error in it. To work it should have been:

=IFERROR(INDEX('Feild Inventory'!$F:$F,MATCH(1,((Quotation!$G$9='Feild Inventory'!$B:$B)*(Quotation!$B15='Feild Inventory'!$D:D)),0)),"")

However, if the part number/SLOC combination is unique, and you have large numbers of rows(you do), it might be better to use SUMIFS:

=IF(B15="","",SUMIFS('Feild Inventory'!F:F,'Feild Inventory'!B:B,Quotation!$G$9,'Feild Inventory'!D:D,Quotation!B15))