vba conditional format

  1. Z

    VBA: Help with IF-THEN-ELSE Statement

    Hello, I'm trying to use an IF-Then-Else Statement, but no matter what I try, I can't ever get it to work. It seems to hate me... 😕 I've used two examples online. As written, they work using their own sample data. But if I make even one simple change, it fails, and I can't figure it out. Any...
  2. B

    Is there a better way to apply conditional formats with vba?

    Hello everyone. I have a large macro that has evolved over time and has become quite slow. I'm making an effort to go through the code to clean it up. There are two conditional formats in the macro that apply different conditions to the range A8:I500 based on the left values in column A. I'm...
    • bbalch
    • Thread
    • conditional formats vba conditional format vba help vba speed
    • Replies: 1
    • Forum: Excel Questions
  3. B

    VBA help - to apply conditional format

    I need some help making modifications to vba that applies conditional formats to one of my reports. The existing macro creates a conditional format and copies the format over the entire report. The vba I use creates a conditional format on cell $A8 and bolds the cell if it starts with " ["...
    • bbalch
    • Thread
    • format cells in vba vba vba - help vba conditional format
    • Replies: 0
    • Forum: Excel Questions
  4. S

    Count conditional formatiing results by icon?

    Hi there, I'm new to this forum so bear with me, if this question's already been discussed in a previous thread. If so, I haven't been able to find it and would appreciate a link :-) I am looking for a way to count the number of green, yellow and red flags (xl3flags) that my conditional...
  5. J

    VBA to change font size and add borders to a range based on selection from a comboBox

    Hello everyone at Mr excel. Please forgive me if I sound a bit naive in the description of my problem. I'm neither a beginner nor an expert. I know just enough to get me in trouble. My particular problem is I have a spreadsheet that populates it cells from seven other sheets in my workbook based...
    • j3rdy
    • Thread
    • vba add borders vba change font size vba conditional format
    • Replies: 3
    • Forum: Excel Questions
  6. T

    Multivlookup

    Hi all, I'm new to this forum but hope you can help me out! I have created a calendar in Excel that works by using a 'multivlookup' function that I have defined as; Public Function MultiVLookup(MatchWith As String, TRange As Range, col_index_num As Integer) MatchWith = LCase$(MatchWith) If...
  7. R

    Prevent paste from wiping out conditional format?

    Due to some problems copy/paste causes if copying data from one cell with no conditional format to a cell containing conditional format... simple paste wipes out the destination's conditional format settings... I'm trying to build a VBA macro that if trying to use "Paste" to change cell...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top