Conditional formatting for specific cells in a table

MCDR929

Hello all - 

For an automated email output, I am attempting to create rules that would color a cell either red, yellow, or green based on values of the cell, within given parameters.  

My input table contains 4 SKU numbers for each warehouse, and the amount on hand.  So, let's say that for NJ1, SKU 16 needs to be green if the OnHand value is >=7, yellow if 4-6, and red if <=3.  Each warehouse has specific parameters for what values fall within each color.

I have become somewhat familiar with table config (can color full rows or columns), but I'm struggling with how and where to enter my if/elseif's for this more complex task.  I am new to writing the formulas, and so far, I just keep getting errors.  Can someone please assist with how this formula should look in the row/column rules? Can this even be done? 

Thanks in advance!

WHSE	SKU	OnHand
NJ1	16	14
NJ1	20	22
NJ1	25	8
NJ1	33	4
CA1	16	2
CA1	20	12
CA1	25	8
CA1	33	7
OH1	16	14
OH1	20	10
OH1	25	9
OH1	33	5

JoeS

I have put together a very simple example and attached it here.

As you can see I created a field in the data called RAG, this is then what I used in the table tool to work out what colour I needed the line to be.

Hopefully that's what you meant and it helps.

Thanks

Joe

RAG_Workflow.yxmd