Conditional Formatting can be used to provide up to 3 different
formats (colours etc) depending on some condition, as well as a fourth
(default) format for none of the conditions being met. If you want to
set up to 10 different conditional formats then you will need to use a
macro.
Alternatively, you could download Bob's add-in CFPlus from this link:
http://www.xldynamic.com/source/xld.....Download.html
and this will give you up to 30 different Conditional Formats.
Hope this helps.
Pete
On Mar 15, 4:08 pm, Padraigglynn
wrote:
I have trawled through the discussion group and am unable to find the answer
to a simple question. I want to change the cell colours of a list if they
match to certain items. I have 10 items in total which I wish to highlight on
a list I have. Any help greatly appreciated. Thanks for your help