color row based on value

  1. D

    Colour Entire Table Row Based on Values in Two Cells

    Hi Folks, I haven't had a chance to use VBA in quite awhile and so I've fallen out of practice. I have a worksheet with 17,000 rows (growing by approx 1000 a month) and conditional formatting set to change the fill colour of some rows (entire table row) based on the values in column 12 and 13...
  2. S

    VBA If Statement Help

    Having some trouble with the code below. I am trying to color all rows with yellow fill and red text if the Word "Catalyst" appears within a string in any cell in column A regardless of spacing between other words. I'm not sure where I'm going wrong so wondering if anyone can take a look at the...
  3. S

    Re: VB code to color row text based on date being greater than system date

    Re: VB code to color row text based on date being greater than system date Hello, I have an urgent need for a VBA script that will color an entire rows text red, if the date found in Column U is greater than 6 months of the system date. I have tried myself with no avail. I found this thread...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top