software

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.: quot;NETquot; thanks

=CELL()=quot;NETquot; does not seem to work

You'll need to stipulate a range.

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

=COUNTIF(1:1,quot;Netquot;)gt;0
OR
=COUNTIF(1:3,quot;Netquot;)gt;0

Same for columns:

=COUNTIF(A:A,quot;Netquot;)gt;0
OR
=COUNTIF(A:C,quot;Netquot;)gt;0

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
quot;nastechquot; gt; wrote in message
...
gt; Hi, trying to find how to describe any cell number, for cond. formatting.
gt; 1st cond. uses absolute / fixed cells. for 2nd cond. need to wildcard?
for
gt; any cell that equals, e.g.: quot;NETquot; thanks
gt;
gt; =CELL()=quot;NETquot; does not seem to workThankyou! 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.

quot;Ragdyerquot; wrote:

gt; You'll need to stipulate a range.
gt;
gt; If you're polling an entire row or rows, try something like:
gt;
gt; =COUNTIF(1:1,quot;Netquot;)gt;0
gt; OR
gt; =COUNTIF(1:3,quot;Netquot;)gt;0
gt;
gt; Same for columns:
gt;
gt; =COUNTIF(A:A,quot;Netquot;)gt;0
gt; OR
gt; =COUNTIF(A:C,quot;Netquot;)gt;0
gt;
gt; --
gt; HTH,
gt;
gt; RD
gt;
gt; ---------------------------------------------------------------------------
gt; Please keep all correspondence within the NewsGroup, so all may benefit !
gt; ---------------------------------------------------------------------------
gt; quot;nastechquot; gt; wrote in message
gt; ...
gt; gt; Hi, trying to find how to describe any cell number, for cond. formatting.
gt; gt; 1st cond. uses absolute / fixed cells. for 2nd cond. need to wildcard?
gt; for
gt; gt; any cell that equals, e.g.: quot;NETquot; thanks
gt; gt;
gt; gt; =CELL()=quot;NETquot; does not seem to work
gt;
gt;