Re: Conditional Formatting with more than 3 Criteria

You can color the font but not background with up to 6 conditions using John
McGimpsey's formatting.

http://www.mcgimpsey.com/excel/conditional6.html

Background color change would require VBA


Gord Dibben MS Excel MVP

On Mon, 30 Oct 2006 23:50:02 -0800, enginguven
<enginguven@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

This is a clever idea but indeed I have another item that is "White". Is
there any way to do that by 5 criteria without a Macro code or no way anymore?

"hot dogs" wrote:

Set the normal format of the cell as Red, then enter the larger than 1,2 and
3 conditions in the allowable conditional formats.

"enginguven" wrote:

I want to find out a way to use conditional formatting for 4 criteria. Is
there any way to do this without using Macro? It should work like:

If the cell value is bigger than 3 it is "Green"
If the cell value is bigger than 2 it is "Blue"
If the cell value is bigger than 1 it is "Yellow"
If the cell value is bigger than 0 it is "Red"

I would appreciate if anyone helps me! I need a quick answer!! Thanks!!

.

Relevant Pages

  • Re: Paste formatted text from Word into Excel.
    ... I am pasting into a cell, ... Excel with the features already marked. ... Formatting part of the text in a cell is clunky in Excel, ...
    (microsoft.public.word.docmanagement)
  • Re: code to shade row then return it to as it was
    ... Dim CellColour As Variant ... 'choose cell colour based on formula in AB ... "Rick Rothstein" wrote: ... row and is formatted the same as the rows beneath but this formatting will ...
    (microsoft.public.excel.programming)
  • Re: How to test an adjacent cell for blank in conditional formatting
    ... I gave this the same pattern color, but added the border. ... If that cell ... conditional formatting, to do one or the other, or even both, if every ...
    (microsoft.public.excel)
  • Re: format empty table cells
    ... in which the table is a paragraph that contains paragraphs ... An easy way around it is to take advantage of the fact that every table cell ... every table cell will have the formatting you want! ... It starts out by inheriting all of the properties of normal style, ...
    (microsoft.public.mac.office.word)
  • Re: Help With Conditional Formatting
    ... formatting from another website but cell K223 ... All I want to do is if the date in the cell is 14 days or less away to be ... "David Biddulph" wrote: ... Column K is the requested delivery date from the customer, ...
    (microsoft.public.excel.misc)