I am creating a report, and I want to shade alternate cells in a light grey colour. I need all columns and rows, starting at A5, that contains numbers to be filled. As I am adding information in the sheet everyday it expands, so I want the code to follow the expansion.
Also, I want row I5 to be red whenever the number is less than 0.
I have tried conditional formatting but it doesnt work!!