View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nicole Nicole is offline
external usenet poster
 
Posts: 53
Default how do i get more than 3 colours in conditional formatting

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!