skip to main | skip to sidebar

Yes/No MsgBox

Friday, March 20, 2009

searching for a word in a column

searching for word Manager in the column 'Job Title' and make it bold if it have



=CONCATENATE("<DIV",IF(ISERROR(SEARCH("Manager",[Job Title],1))," "," style='font-weight:bold;'"),">",[First Name]," ",[Last Name],"</DIV>")







Posted by akella at 3:38 AM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2010 (2)
    • ►  July (2)
  • ▼  2009 (22)
    • ►  November (4)
    • ►  September (3)
    • ►  June (1)
    • ►  May (3)
    • ▼  March (8)
      • Nth Highest salary and Fetching column values for ...
      • preparing Insert statement for the ros exst in tab...
      • Regular expression for a Foramt 'XX99999X'
      • Expand/Collapse GV
      • options for a Question and Tips of DataTable and ...
      • searching for a word in a column
      • Restoring the Quick Launch Bar in Web Part Pages
      • SPSite and SPWeb
    • ►  February (2)
    • ►  January (1)
  • ►  2008 (3)
    • ►  May (2)
    • ►  April (1)

About Me

akella
View my complete profile