Any column below the stock Level, status become to red.
Options
richard_uy
✭✭
Hi,
As per the attached and formula, How can i add the formula if Week 15,16,17~52 any column below the stock Level, status become to red.
I'm only know the formula for single column.
=IF(ISBLANK([Stock Level]2), "Yellow", IF([Stock Level]2 <= [Week 14]2, "Green", IF([Stock Level]2 > [Week 14]2, "Red", "")))
Thanks in advance.
Comments
-
Hi,
Maybe you could use COUNTIF? Something like :
"=IF(COUNTIF([Week 14]2: [Week 52]2 ,"<"+ [Stock Level]2)>0,"Red","Green")"
That means : if there is more than 0 week that are > Stock Level, then Red. Else Green.
Does this helps?
Paul.
-
Hi Paul,
Can't work for the said formula.
-
Anyone help, i'm really need this formula.