Conditional Format (exclude 0)

's Computer Specifications

Excel2003 ... Range A6:G6 contains Formula's

Cell A6 contains a Name (returned by formula)
Range B6:G6 contains values 0 to 7 (returned by formula & may repeat)

I wish to set conditional formatting in Cell A6

Condition = when value in Range B6:G6 is >=1 & <5.

Thanks ... Kha

's Computer Specifications

Hi,

What do you want to happen when your condition has met?????

Thanks,
--
Farhad Hodjat

"Ken" wrote:

> Excel2003 ... Range A6:G6 contains Formula's
>
> Cell A6 contains a Name (returned by formula)
> Range B6:G6 contains values 0 to 7 (returned by formula & may repeat)
>
> I wish to set conditional formatting in Cell A6
>
> Condition = when value in Range B6:G6 is >=1 & <5.
>
> Thanks ... Kha
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Average of cells that exclude conditional formats?	AHartong	Microsoft Excel Worksheet Functions	5	7th Aug 2009 02:09 PM
Conditional Formatting to Exclude Weekends	=?Utf-8?B?Mm1hbnlwdXBwaWVz?=	Microsoft Excel Worksheet Functions	4	29th May 2007 07:59 PM
Conditional formatting to exclude weekend and Bank Holidays	Paul	Microsoft Excel Worksheet Functions	1	27th May 2007 05:48 PM
How to exclude conditional calculated no or zero values from a cha	=?Utf-8?B?RnJvZG8=?=	Microsoft Excel Charting	2	12th Apr 2006 11:23 AM
MIN value exclude '0' & Conditional Formatting	JEM	Microsoft Excel Worksheet Functions	5	16th Apr 2004 03:40 AM