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)="1"
--
Regards Ron de Bruin
http://www.rondebruin.nl
"nastech" wrote in message ...
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)="1")