View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
neostar77 neostar77 is offline
external usenet poster
 
Posts: 5
Default Format - Conditional Formating

In MS-Excel 2003, we have this feature under Tools - Condtional Formatting
where you can set the following criteria:

If value between 1 to 100, then you can click "Format" button and then set
the Pattern color.

Then make another value range say - 101 to 200, and make another Pattern
color.

Then another value range - 201 and above, another pattern color.

In MS-Excel 2007, I'm lost. I struggled alot to find what I'm looking for,
and can't find that at all.

How do I go about setting Pattern colors and conditional formatting using
MS-Excel 2007?