Re: Conditional formatting code wont work

I recently answered a similar question with a full code example. try
searching this NG

"Robert Hargreaves" <nrgsav@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:42a33353$1_4@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hi I am trying to code my conditional formatting as I have more than 3
> clauses to use.
>
> I cant seem to get the code to work no matter what I name the sub. What
> do I need to name it?
>
> Select Case ActiveCell.Value
> Case > namedrange1 And < namedrange2
> Selection.Interior.ColorIndex = 6
> Case >namedrange2 And <namedrange 3
> Selection.Interior.ColorIndex = 5
> End Select
>
> If I need to write some more code what would it include?
>
> Thanks for your help.
> Rob
>
>


.

Relevant Pages

  • more than 3 conditions in conditional formatting - possible?
    ... Is it possible to have more than 3 conditions using conditional formatting? ... I am dealing with text and not numbers which makes it a little harder to ... Cheers, rob ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: Any way to highlight rows without using macros?
    ... by searching for "highlight entire row conditional formatting" ... > I thought I used to be able to highlight rows containing certain text, ... Conditional formatting will only work ... > I work a lot with filtered lists, and if there were some way to show ...
    (microsoft.public.excel.misc)
  • Re: No difference in small/big caps
    ... I've done some searching and here's the trick in case anyone else needs: ... > sounds like your Conditional Formatting is being done with XSLT, ... >> LETTERS and big letters? ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: If File.Exists Else question
    ... that's searching the path for the file, ... Jon Skeet - ... If replying to the group, please do not mail me too ... Prev by Date: ...
    (microsoft.public.dotnet.general)
  • Re: Is it possible to monitor how many times a word occurs in a docume
    ... is there a way in Microsoft Word to find out how ... I know there's a tool for it in Adobe Acrobat, ... Prev by Date: ...
    (microsoft.public.word.docmanagement)