Is it possible to highlight cells based on another cell. That is a bit of an oversimplification. My table looks something like this:
<tbody>
</tbody>
If the entries under Options w to Z match choice 1 to 4 I want to highlight in green, if options W to Z match entries under Choice 5 and 6 I want to highlight in yellow. Is there any way this can be done. So the table should look like:
<tbody>
</tbody>
As always, any help is very much appreciated.
Thanks
Choice 1 | Choice 2 | Choice 3 | Choice 4 | Choice 5 | Choice 6 | Option W | Option X | Option Y | Option Z |
History | Spanish | Media | RS | PE | Art | History | Spanish | Art | RS |
<tbody>
</tbody>
If the entries under Options w to Z match choice 1 to 4 I want to highlight in green, if options W to Z match entries under Choice 5 and 6 I want to highlight in yellow. Is there any way this can be done. So the table should look like:
Choice 1 | Choice 2 | Choice 3 | Choice 4 | Choice 5 | Choice 6 | Option W | Option X | Option Y | Option Z |
History | Spanish | Media | RS | PE | Art | History | Spanish | Art | RS |
<tbody>
</tbody>
As always, any help is very much appreciated.
Thanks