Feb 09 2017
06:19 AM
- last edited on
Jul 25 2018
09:25 AM
by
TechCommunityAP
Feb 09 2017
06:19 AM
- last edited on
Jul 25 2018
09:25 AM
by
TechCommunityAP
Hi,
What formula would I need to enter to turn an entire row a colour based on a comparing a quantity Column with a needed Column and then would it be possible for it to be Red if Zero, Yellow if some but less than required and green if quantity required is reached.
Thanks
Az
Feb 09 2017 07:12 AM
I guess you need 3 rules, for each colour one. Assuming your quantity is in the column A, bar quantity is 4 (or absolute cell reference where you have it) and it applies for the first 50 rows
for the green it''ll be
formula =($A1>=4)
applies to $1:$50
add green color to fill
and put this rule on the top;
For the Yellow same but =($A1>0)
and the rule is on the second position
For the Red same but =($A1<=0)
and the rule is on the third position