+ Reply to Thread
Results 1 to 2 of 2

VBA formula for conditional formatting?

  1. #1
    Registered User
    Join Date
    11-04-2019
    Location
    Phoenix, AZ
    MS-Off Ver
    Microsoft Excel for Mac
    Posts
    1

    VBA formula for conditional formatting?

    Is there any way to create a VBA formula that would apply conditional formatting using information in one cell, and apply it to a different cell? For example:



    Screen Shot 2019-11-04 at 8.27.35 PM copy.png




    In the picture above, I have a value in column K. There is also a value in column T. I want to be able to use conditional formatting so that it highlights red when the value of column K is below the value of column T. I also want to be able to use conditional formatting so that it highlights green when the volume of column K is above the value of column T.

    I also need to do this for 200+ rows, and each value in column T is different. Is there anyway to create a VBA formula so that I would not have to do this manually for each row?
    Attached Images Attached Images

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,123

    Re: VBA formula for conditional formatting?

    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Be very, very careful using IFERROR ! It hides ALL errors which is not always what you want to get correct results

+ 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: 3
    Last Post: 06-19-2015, 07:16 AM
  2. Formatting Cells with Date or Text Values in a Conditional Formatting Formula
    By Phil Hageman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-15-2014, 09:36 AM
  3. Opening xlsm files with conditional formatting opens with removed conditional formatting
    By Martijn.Steenbakker in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2014, 05:38 AM
  4. If Formula - conditional formatting - three different formatting rules
    By sharper1989 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-25-2014, 04:49 PM
  5. Replies: 3
    Last Post: 11-28-2013, 02:11 AM
  6. Replies: 1
    Last Post: 07-19-2012, 05:37 AM
  7. Replies: 6
    Last Post: 03-12-2006, 06:30 PM

Tags for this Thread

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