So hi everyone, hope you are all having a good day 🙂

ok so in this table the main focus is on the marks and the score, which I used conditional formatting on to have the cell in the www column be green if they are the same and orange if they are not.

This all works fine but duplicating this table the conditional formatting is only connected to the first set of data and won’t pass over? I need around 30 of these tables so would prefer it to be duplicatable if possible? rather than creating rules (12 x 30) times ha.

I have tried officially making it a table but that didn’t seem to work either but I feel like I’m getting closer?

A table like this I can just duplicate and then input the score?

​So hi everyone, hope you are all having a good day 🙂 ok so in this table the main focus is on the marks and the score, which I used conditional formatting on to have the cell in the www column be green if they are the same and orange if they are not. This all works fine but duplicating this table the conditional formatting is only connected to the first set of data and won’t pass over? I need around 30 of these tables so would prefer it to be duplicatable if possible? rather than creating rules (12 x 30) times ha. I have tried officially making it a table but that didn’t seem to work either but I feel like I’m getting closer? A table like this I can just duplicate and then input the score?  Read More

​