Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I get rid of a 2nd instance (xls:2)? | Excel Discussion (Misc queries) | |||
Identifying First Instance of a Value Given a Criteria | Excel Worksheet Functions | |||
internet explorer instance | Excel Discussion (Misc queries) | |||
Keep Excel from opening new instance | Excel Discussion (Misc queries) | |||
Return only one instance | Excel Worksheet Functions |