Re: Conditional formatting code wont work

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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: 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)
  • Re: Conditional formatting based on Cell Value and another cells
    ... Hi, Pete. ... searching for an answer for this issue. ... If E3 is shaded manually rather than through conditional formatting, ... you'd need some VBA to do that. ...
    (microsoft.public.excel.worksheet.functions)