View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default how do i get more than 3 colours in conditional formatting

FYI:

xl2007 offers lots more.

Nicole wrote:

I have tried to download bob's add in but this comes up with an error.

I need a code to show different colours when I type R, A, C, I, RA. I have
tried using the code written which seems to work fine for numbers but not
text...HELP!


--

Dave Peterson