?? call it: general cell() ??

N

nastech

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
 
R

Ragdyer

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
 
N

nastech

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.
 
Top