Thread: First Instance
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Howard Howard is offline
external usenet poster
 
Posts: 40
Default 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