View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin
 
Posts: n/a
Default format whole row..

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")