First Instance
 

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

First Instance
 

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

First Instance
 

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

First Instance
 

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

First Instance
 

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

First Instance
 

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

First Instance
 

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

First Instance
 

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

First Instance
 

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