Conditional formatting

[Azrael Johnston]

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

[#2]

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