LinkBack URL
About LinkBacks
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.
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.
Last edited by mma3824; 12-01-2020 at 01:00 PM.
Try this. Please let me know if you have any questions.
Did you put in a formula? It seems to be working but I cant find what you put in?
Last edited by mma3824; 11-20-2020 at 05:07 PM.
Did you put in a formula? It seems to be working but I cant find what you put in?
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.
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.
If you have changed something, the original sample sheet may no longer be relevant. Please add an appropriate sample sheet.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Glenn,
I have the most recent example with the changes in my last comment.
Thanks
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))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks