Excel 2003
In a column of numbers, I want to highlight (bold) the first number, and
only the first number, over 200.
What formula do I use in conditional formatting?

Thanks,

--
Howard

I selected column D and with D1 the activecell, I used this formula:

=AND(ISNUMBER(D1),COUNT($D$1:D1)=1)



Howard wrote:

Excel 2003
In a column of numbers, I want to highlight (bold) the first number, and
only the first number, over 200.
What formula do I use in conditional formatting?

Thanks,

--
Howard

--

Dave Peterson

if it is in column A starting at row 1

Cell A1
=if(countif((A$1:A1),"200")=1,true,false)
the copy this conditional formula to the rest of the column.
Use the Paint brush on the tool bar to copy conditional formats.
Highlight first cell with conditional format, press paint brush, highight
rest of column

"Howard" wrote:

Excel 2003
In a column of numbers, I want to highlight (bold) the first number, and
only the first number, over 200.
What formula do I use in conditional formatting?

Thanks,

--
Howard

Or, presumably, just =countif(A$1:A1,"200")=1 ?
--
David Biddulph

"Joel" wrote in message
...
if it is in column A starting at row 1

Cell A1
=if(countif((A$1:A1),"200")=1,true,false)
the copy this conditional formula to the rest of the column.
Use the Paint brush on the tool bar to copy conditional formats.
Highlight first cell with conditional format, press paint brush, highight
rest of column

"Howard" wrote:

Excel 2003
In a column of numbers, I want to highlight (bold) the first number, and
only the first number, over 200.
What formula do I use in conditional formatting?

Thanks,

--
Howard

Thanks to both of you for your responses.
Joel, it works perfectly!

Thanks,
--
Howard


"Joel" wrote:

if it is in column A starting at row 1

Cell A1
=if(countif((A$1:A1),"200")=1,true,false)
the copy this conditional formula to the rest of the column.
Use the Paint brush on the tool bar to copy conditional formats.
Highlight first cell with conditional format, press paint brush, highight
rest of column

"Howard" wrote:

Excel 2003
In a column of numbers, I want to highlight (bold) the first number, and
only the first number, over 200.
What formula do I use in conditional formatting?

Thanks,

--
Howard

I missed the part about 200.

I'd use:
=AND(ISNUMBER(D1),D1200,COUNTIF($D$1:D1,"200")=1 )



Dave Peterson wrote:

I selected column D and with D1 the activecell, I used this formula:

=AND(ISNUMBER(D1),COUNT($D$1:D1)=1)

Howard wrote:

Excel 2003
In a column of numbers, I want to highlight (bold) the first number, and
only the first number, over 200.
What formula do I use in conditional formatting?

Thanks,

--
Howard

--

Dave Peterson

--

Dave Peterson

I'd check it again.

Put 201 in A1
and any number smaller than 200 in A2:a5






Howard wrote:

Thanks to both of you for your responses.
Joel, it works perfectly!

Thanks,
--
Howard

"Joel" wrote:

if it is in column A starting at row 1

Cell A1
=if(countif((A$1:A1),"200")=1,true,false)
the copy this conditional formula to the rest of the column.
Use the Paint brush on the tool bar to copy conditional formats.
Highlight first cell with conditional format, press paint brush, highight
rest of column

"Howard" wrote:

Excel 2003
In a column of numbers, I want to highlight (bold) the first number, and
only the first number, over 200.
What formula do I use in conditional formatting?

Thanks,

--
Howard

--

Dave Peterson

Another one:

Range of interest = A10:A20

=A10=INDEX(A$10:A$20,MATCH(1,--(A$10:A$20200),0))

Assumes no text entries in the range

Biff

"Howard" wrote in message
...
Excel 2003
In a column of numbers, I want to highlight (bold) the first number, and
only the first number, over 200.
What formula do I use in conditional formatting?

Thanks,

--
Howard

Just getting back to this. Thanks for your clarification.
--
Howard


"Dave Peterson" wrote:

I missed the part about 200.

I'd use:
=AND(ISNUMBER(D1),D1200,COUNTIF($D$1:D1,"200")=1 )



Dave Peterson wrote:

I selected column D and with D1 the activecell, I used this formula:

=AND(ISNUMBER(D1),COUNT($D$1:D1)=1)

Howard wrote:

Excel 2003
In a column of numbers, I want to highlight (bold) the first number, and
only the first number, over 200.
What formula do I use in conditional formatting?

Thanks,

--
Howard

--

Dave Peterson

--

Dave Peterson