Results 1 to 5 of 5

VBA call function based on change and bg-color

Threaded View

vba2025 VBA call function based on... 11-13-2024, 10:10 AM
AliGW Re: VBA call function based... 11-13-2024, 10:24 AM
JohnTopley Re: VBA call function based... 11-13-2024, 10:28 AM
vba2025 Re: VBA call function based... 11-14-2024, 07:44 AM
vba2025 Re: VBA call function based... 11-14-2024, 07:44 AM
  1. 11-13-2024, 10:28 AM #3
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,920

    Re: VBA call function based on change and bg-color

    Formula: copy to clipboard 
    =if(and(h$2>=$b3,h$2<=$c3),$e3,"")


    CF

    =LEN(H3)>0
    Attached Files Attached Files
    Last edited by JohnTopley; 11-13-2024 at 11:16 AM.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. call background color change on future date
    By jafoster in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-14-2021, 09:55 PM
  2. change background textbox color based on text color in cell
    By atadaliran in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-05-2021, 05:34 AM
  3. [SOLVED] Need to change cell color based off of RGB Color being defined in 3 cells
    By Chris McGlothen in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-01-2017, 02:13 PM
  4. [SOLVED] change fill color of a range of cells based on color of a cell?
    By DarMelNel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-20-2014, 04:48 PM
  5. Change Font Color Based On Adjacent Cell Color
    By Zorro9758 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-11-2013, 02:47 PM
  6. VBA / Macro help needed to change the barchart color based on Cell Color
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-28-2012, 09:15 AM
  7. Function to change text color based on date?
    By Ahroo in forum Excel General
    Replies: 2
    Last Post: 08-09-2006, 10:49 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1