You'll need to stipulate a range.

If you're polling an entire row or rows, try something like:

=COUNTIF(1:1,"Net")0
OR
=COUNTIF(1:3,"Net")0

Same for columns:

=COUNTIF(A:A,"Net")0
OR
=COUNTIF(A:C,"Net")0

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"nastech" wrote in message
...
Hi, trying to find how to describe any cell number, for cond. formatting.
1st cond. uses absolute / fixed cells. for 2nd cond. need to wildcard?
for
any cell that equals, e.g.: "NET" thanks

=CELL()="NET" does not seem to work