View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
David McRitchie David McRitchie is offline
external usenet poster
 
Posts: 903
Default Conditional Formatting for more than 3 conditions

True but unfortunately if you look up words like conditional formatting
in a search that isn't going to help much with finding the solutions
with extended formatting. It might help to include limit* 3 OR three
of course adding your name to the search would help, but that is
not something the person would know ahead of time -- though maybe
the suggestion is just the way find them now at the time of posting..

google groups search: conditional.formatting 3 OR three author:patrick.molloy

(note the period instead of using double quote for "patrick molloy")
Anyway that limits it to 55:

and not very recent, okay change it to
google groups search: conditional.formatting author:patrick.molloy .
(sorted by date) I'll bet the results still aren't what you expected.

Anyway it is hard to search for answers for things that are most commonly
done differently. Likewise there are so many answers that if you
misspell a word on a normal search you'll still get a hit and that's not
even taking into account that Google will suggest a new search with
the word spelled as Google has found it more often spelled..
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Patrick Molloy" wrote in message
...
there has been a lot of post on this topic, Please search. I have put several
answers as have several others.

"Jim Brass" wrote:

Hi
My son is tracking the weather. He keeps track of all the temps. He
would like to conditionally format them in increments of 10 degrees(eg.
70's- blue; 80's - purple; etc.).
How can he do it for more than 3 conditions? Thanks Jim