software

Hi, looking for way to cond. format whole row for 3 dif conditions left = 1 2
or 3.

trying to find something bit dynamic like: (not quite working, thanks)
=OR(LEFT(CELL(),1)=quot;1quot;)

Select the whole row (click on the row header)

When you do this for row 1 A1 is active

Use this formula for the first condition
=LEFT(A1,1)=quot;1quot;--
Regards Ron de Bruin
www.rondebruin.nlquot;nastechquot; gt; wrote in message ...
gt; Hi, looking for way to cond. format whole row for 3 dif conditions left = 1 2
gt; or 3.
gt;
gt; trying to find something bit dynamic like: (not quite working, thanks)
gt; =OR(LEFT(CELL(),1)=quot;1quot;)
Something like

=OR(LEFT($A1,1)=quot;1quot;,LEFT($A1,1)=quot;2quot;,LEFT($A1,1)=quot;3 quot;)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;nastechquot; gt; wrote in message
...
gt; Hi, looking for way to cond. format whole row for 3 dif conditions left =
1 2
gt; or 3.
gt;
gt; trying to find something bit dynamic like: (not quite working, thanks)
gt; =OR(LEFT(CELL(),1)=quot;1quot;)
quot;nastechquot; wrote:
gt; looking for way to cond. format
gt; whole row for 3 dif conditions left = 1 2 or 3.
gt; trying to find something bit dynamic like:
gt; (not quite working, thanks)
gt; =OR(LEFT(CELL(),1)=quot;1quot;)

Assuming we have text data within col A, eg:

1A
2B
3C
1E
1K
3K
etc

then we could select the entire sheet (with A1 active)
and use something like this
as the CF conds 1 - 3's quot;Formula isquot;

Cond1: =LEFT($A1,1) 0=1
Cond2: =LEFT($A1,1) 0=2
Cond3: =LEFT($A1,1) 0=3

The CF would color the entire row*
based on the leftmost digit in col A
*the dollar sign in quot;$A..quot; is the key for entire row formatting
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
thanks..

quot;Ron de Bruinquot; wrote:

gt; Select the whole row (click on the row header)
gt;
gt; When you do this for row 1 A1 is active
gt;
gt; Use this formula for the first condition
gt; =LEFT(A1,1)=quot;1quot;
gt;
gt;
gt; --
gt; Regards Ron de Bruin
gt; www.rondebruin.nl
gt;
gt;
gt; quot;nastechquot; gt; wrote in message ...
gt; gt; Hi, looking for way to cond. format whole row for 3 dif conditions left = 1 2
gt; gt; or 3.
gt; gt;
gt; gt; trying to find something bit dynamic like: (not quite working, thanks)
gt; gt; =OR(LEFT(CELL(),1)=quot;1quot;)
gt;
gt;
gt;

thanks..

quot;Bob Phillipsquot; wrote:

gt; Something like
gt;
gt; =OR(LEFT($A1,1)=quot;1quot;,LEFT($A1,1)=quot;2quot;,LEFT($A1,1)=quot;3 quot;)
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;nastechquot; gt; wrote in message
gt; ...
gt; gt; Hi, looking for way to cond. format whole row for 3 dif conditions left =
gt; 1 2
gt; gt; or 3.
gt; gt;
gt; gt; trying to find something bit dynamic like: (not quite working, thanks)
gt; gt; =OR(LEFT(CELL(),1)=quot;1quot;)
gt;
gt;
gt;

Hi, that works great,.. Is there a modifcation to that for where cursor is,
cond. format takes effect? thanks..

quot;Maxquot; wrote:

gt; quot;nastechquot; wrote:
gt; gt; looking for way to cond. format
gt; gt; whole row for 3 dif conditions left = 1 2 or 3.
gt; gt; trying to find something bit dynamic like:
gt; gt; (not quite working, thanks)
gt; gt; =OR(LEFT(CELL(),1)=quot;1quot;)
gt;
gt; Assuming we have text data within col A, eg:
gt;
gt; 1A
gt; 2B
gt; 3C
gt; 1E
gt; 1K
gt; 3K
gt; etc
gt;
gt; then we could select the entire sheet (with A1 active)
gt; and use something like this
gt; as the CF conds 1 - 3's quot;Formula isquot;
gt;
gt; Cond1: =LEFT($A1,1) 0=1
gt; Cond2: =LEFT($A1,1) 0=2
gt; Cond3: =LEFT($A1,1) 0=3
gt;
gt; The CF would color the entire row*
gt; based on the leftmost digit in col A
gt; *the dollar sign in quot;$A..quot; is the key for entire row formatting
gt; --
gt; Max
gt; Singapore
gt; savefile.com/projects/236895
gt; xdemechanik
gt; ---
gt;
gt;
gt;

quot;nastechquot; wrote:
gt; Hi, that works great,..

Glad to hear that !

gt; Is there a modifcation to that for where cursor is,
gt; cond. format takes effect?

Ah, think it's not possible via normal CF lt;ggt;

Not sure about vba though,
but that route's beyond my depth to offer

Hang around awhile to see whether Ron / Bob, or
others versed in vba might jump in with something for you

In the interim, perhaps a possible quot;fuzzyquot; fit lt;ggt;
as to the cursor sensitive mod you're after
might be Chip's RowLiner:
www.cpearson.com/excel/RowLiner.htm

--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
Maybe I don't understand your question, as it seems it was in Max's
reply, perhaps this is a bit more explicit..

The formula used is based on the active cell location when the formula
is entered. The formula with adjustments relative to that active cell
is applied to all cells in the selection. The $A means that for each
cell on the row the column A cell will be the cell tested. See
www.mvps.org/dmcritchie/excel/condfmt.htm

So if you used A1 it would be testing it's own cell if A1 were the active
cell with $A1 being test your cursor could be anywhere on Row 1 to
get the same result for that address in the formula.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;nastechquot; gt; wrote in message ...
gt; Hi, that works great,.. Is there a modifcation to that for where cursor is,
gt; cond. format takes effect? thanks..

gt; gt; Cond1: =LEFT($A1,1) 0=1
gt; gt; Cond2: =LEFT($A1,1) 0=2
gt; gt; Cond3: =LEFT($A1,1) 0=3
gt; gt;
gt; gt; The CF would color the entire row*
gt; gt; based on the leftmost digit in col A
gt; gt; *the dollar sign in quot;$A..quot; is the key for entire row formatting
gt; gt; --
gt; gt; Max
gt; gt; Singapore
gt; gt; savefile.com/projects/236895
gt; gt; xdemechanik
gt; gt; ---
gt; gt;
gt; gt;
gt; gt;