Forum Discussion
Specific conditional formatting for each table?
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?
5 Replies
What do the rules currently look like?
By the way, it looks like you have individual rules for each row. Just one rule for the entire range is sufficient. Let's say you want to conditionally format K41:K100.
Select this range. K41 should be the active cell in the selection.
Set the fill color to orange. This will be the default.
On the Home tab of the ribbon, select Conditional Formatting > Clear Rules > Clear Rules from Selected Cells. This deletes the existing rules.
Then select Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula=I41=J41
without $ signs. Remember, the active cell is in row 41.
Click Format...
Activate the Fill tab.
Select green as fill color.
Click OK, then click OK again.When you copy/paste the table, the rule will be adjusted automatically.
- I'm not very proficient in this type of stuff but the only things I can think of off the top of my head is just copying the whole table via click and drag from opposite corners to highlight the section you want to copy then pasting it where you want and editing if necessary, but I'm not sure if that will also copy the conditional formatting. Otherwise, just have all the tables lined up vertically and highlight all of column www then only need to change it once? I'm not sure if this helps at all but good luck!
