First Instance

H

Howard

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,
 
D

Dave Peterson

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

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

Joel

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
 
D

Dave Peterson

I missed the part about >200.

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

T. Valko

Another one:

Range of interest = A10:A20

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

Assumes no text entries in the range

Biff
 
H

Howard

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


Dave Peterson said:
I missed the part about >200.

I'd use:
=AND(ISNUMBER(D1),D1>200,COUNTIF($D$1:D1,">200")=1)
Click to expand...
 
Top