View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
nastech
 
Posts: n/a
Default format whole row..

thanks..

"Bob Phillips" wrote:

Something like

=OR(LEFT($A1,1)="1",LEFT($A1,1)="2",LEFT($A1,1)="3 ")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

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