Forum Discussion

majidsiddique52075's avatar
majidsiddique52075
Copper Contributor
May 05, 2019

Replace item AUTO if not match in invoice No

Hi All, i am working on a sheet on two set of data bases. first is main data and second is invoice data. both are extract from different system software for analysis. main data is perfect and compar...
Formulas and Functions
majidsiddique52075's avatar
majidsiddique52075
Copper Contributor
May 06, 2019

Hi SergeiBaklan 

Thank to reply.

is there any possibility to highlight mismatch item with conditional formatting? 

Thanks.

 

  • majidsiddique52075's avatar
    majidsiddique52075
    Copper Contributor
    May 06, 2019

    SergeiBaklan 

    Thank boss, its working perfect, but i cannot apply vlookup, match or any other formula to count highlight cell. its also required for VBA coding. i really dont know VBA. 

    Thanks for the reply,

    Thanks

     

      • majidsiddique52075's avatar
        majidsiddique52075
        Copper Contributor
        May 06, 2019

        SergeiBaklan 

        its working perfect. thank boss,

        if i insert manually color on the cell then formula is not working. is it for conditional formatting only?

        do you have any other idea to count cell highlighted when i put manually color by theme color window, ( normal cell color )?

        Thanks