Conditional Formatting
Hi,
Is it possible to introduce more than 3 conditions (via conditional
formatting) onto a single spreadsheet?
I have a spreadsheet with 9 columns - the first is for name, then 1st
choice, 2nd choice etc etc...up to 8th choice. There are 8 different things
that could appear in each cell on the same row - and I would like the cell to
change colour automatically according to what appears in it. This would
obviously require 8 conditions - but I seem limited to 3.
Is there a way to increase the number of permissible conditions, or can
anyone think of a way I can achieve this without conditions?
Thanks,
Ian
|