+ Reply to Thread
Results 1 to 2 of 2

convert formula CF to vba CF

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    12-02-2020
    Location
    Asia
    MS-Off Ver
    2010 & 2016 insider(Windows 10 64-bit)
    Posts
    729

    convert formula CF to vba CF

    hello
    I use this formula in condition formatting =COUNTIFS(sheet2!$B:$B,TRIM($B2)&" "&TRIM($C2)&" "&TRIM($D2))=0 to highlight items are not matched in sheet 3 with sheet2 .
    so waht I want convert this formula to vba until if update data in sheet2 to become the items are not matched to matched items and delete the color from sheet3 for item .
    Attached Files Attached Files
    Last edited by abdo meghari; 04-06-2022 at 06:37 AM.

  2. #2
    Forum Contributor
    Join Date
    12-02-2020
    Location
    Asia
    MS-Off Ver
    2010 & 2016 insider(Windows 10 64-bit)
    Posts
    729

    Re: convert formula CF to vba CF

    is there any help?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 03-25-2021, 04:44 AM
  2. fomula
    By sevaa in forum Excel General
    Replies: 3
    Last Post: 03-08-2018, 01:37 AM
  3. [SOLVED] Fomula: How to convert a TEXT into a usable time which can be formatted
    By arekkusu03 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 07-17-2013, 08:04 PM
  4. Need fomula
    By kenzo in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-21-2006, 01:35 PM
  5. [SOLVED] Fomula (if?)
    By Jules in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-08-2006, 02:15 PM
  6. [SOLVED] Fomula
    By Steve in forum Excel General
    Replies: 2
    Last Post: 12-08-2005, 03:35 PM
  7. [SOLVED] Please help, i need a fomula
    By Age Formula?? in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-13-2005, 06:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1