Forum Discussion

Mikecti's avatar
Mikecti
Copper Contributor
Oct 29, 2019

Excel Formula

I’ve got an Excel workbook with multiple worksheets, each one having different numbers of rows and columns. Each worksheet has a variable called flag.  I’m curious if there is some way for Excel to search the entire workbook for cases where flag=‘Flag’ and then highlight the row containing the value.

 

thanks,

Mike

Excel formula help

1 Reply

  • tauqeeracma's avatar
    tauqeeracma
    Iron Contributor
    Oct 30, 2019

    Hi Mikecti 

     

    I am not sure whether a complete row can be highlighted, but you can easily highlight all cells in an entire workbook that contain desired word (Flag).

     

    Click Cltr + F --> type 'Flag' --> select 'workbook' --> click Replace --> type again 'Flag' --> Click Format --> Fill with any color

     

     

    Hope it will help

    Thanks

    Tauqeer

Resources