"nastech" wrote:
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)="1")

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 "Formula is"

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 "$A.." is the key for entire row formatting
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---