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!!

Check out this link...

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

Jim Thomlinson


"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!!

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!!

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!!

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
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!!