View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Conditional Formatting

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