?? call it: general cell() ??
 

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

?? call it: general cell() ??
 

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

?? call it: general cell() ??
 

Thankyou! was exactly what needed. I did not pose question as 2nd part:
for purpose of some header lines, making top/bottom line borders perm..

is there a trick variable for the shortest term possible? don't really need
a condition that matters to set format for some lines. something like =cell()

update, just tried: =row() seems to work, reply if problem with this
idea, else looks good.

"Ragdyer" wrote:

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