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

[Godel314]

What if Excel doesn't support the coloured gradient created in the Alteryx table? When I render to Excel, Excel randomly changes the colour of cells in which the colour is not supported. Any way to get around this?

[JoeS]

---

@Godel314 wrote:

What if Excel doesn't support the coloured gradient created in the Alteryx table? When I render to Excel, Excel randomly changes the colour of cells in which the colour is not supported. Any way to get around this?

---

Could you find the RGB value from Excel and enter that into the Alteryx table?