Conditional formatting code wont work

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

  • Conditional Formatting on Time
    ... Sorry, I just read my post and it might be confusing, hope ... want the conditional formatting to return a specific color. ... Ive set the number category to time and ... but I cant seem to get it to work. ...
    (microsoft.public.excel.programming)
  • conditional formatting with vb code (access 2003)
    ... I am trying to apply conditional formatting. ... I cant find a value that works. ... tried using *ctrl *space after i type in my texbox anme, ...
    (comp.databases.ms-access)
  • Re: Hiding #N/A
    ... > I have tried conditional formatting but cant get the settings right. ... > Outgoing mail is certified Virus Free by AVG. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Calculated Checkbox values
    ... (I guess I cant apply conditional formatting to checkboxes?) ... Lukasz ...
    (microsoft.public.access.gettingstarted)
Loading