Conditional formatting on multiple row not working

Question

Hello,

Conditional formatting works for on a single row but when I try across multiple row it all just picks a single cell.

OK, let me explain better.

I have a spreadsheet, I have 3 columns, A, B and C and there are 100+ rows, so A1 to A100 etc.....

In column A I have "ideal stock level" which is a numerical number

In column B I have "current stock level" which is a numerical number

In column C I have "to order" which is column A-B

On column B I want to color the cells if column C = 0

So I put in the first row conditional formatting to check cell C1 and if 0 color yellow. This works great.

Now on some conditional formatting I can then do a fill down and the formatting follows by changing the formula for the second row to be C2, C3 on the third row but I can't seem to do this now as it just copies $CS1 for ever row I fill down.

Is there a way to change C1 to C2 then C3 etc when filling sown or do I have to do this manually on each of the 100+ rows

Thanks

Answer 1

How is everything going now? Have you tried the steps?

Feel free to share any update.

Answer 2

Hi Repro,

Set as below:

=$C2=0 and applied to =$B$2:$B$100

Best Regards,

Snow Lu