View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
Evans9939
 
Posts: n/a
Default Conditional Formatting from 3 to 5

Hi

I need to set conditional formatting on 5 numbers to highlight any that
match another set of 5 numgers that will change week on week (lottery
numbers). I can set the conditional formatting to highlight any that match
the first 3 numbers, but not the next two.

Is there any way you can increase the conditions from 3 to 5?

Thanks Cathy