+ Reply to Thread
Results 1 to 4 of 4

Overwrite the conditional color format to change color in specific cell

  1. #1
    Registered User
    Join Date
    06-01-2019
    Location
    Chicago
    MS-Off Ver
    2016
    Posts
    53

    Overwrite the conditional color format to change color in specific cell

    I have a macro, where it highlights the alternate rows in a sheet, this is our standard requirement. The challenge is, I need to verify a condition and change the color of only cells in column J when the required condition is met for all rows. I have the below codes. can anyone help me with it.
    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: Overwrite the conditional color format to change color in specific cell

    Yeah, conditional formatting trumps cell formatting. Just convert your day of week tests to conditional formatting and make them the proper priority with respect to your alternating line formatting.
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).

  3. #3
    Valued Forum Contributor
    Join Date
    04-24-2014
    Location
    United States
    MS-Off Ver
    Office 365 ProPlus
    Posts
    830

    Re: Overwrite the conditional color format to change color in specific cell

    Quote Originally Posted by Jimmy1709 View Post
    I have a macro, where it highlights the alternate rows in a sheet, this is our standard requirement.
    Only curious. But is a macro really needed for this? If your data was setup as a table, this will alter the row color shading for you each time you add a new row.

  4. #4
    Registered User
    Join Date
    06-01-2019
    Location
    Chicago
    MS-Off Ver
    2016
    Posts
    53

    Re: Overwrite the conditional color format to change color in specific cell

    @ptmuldoon : This is just a small part of giant macro, which is written to handle many redundant tasks.

+ 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: 2
    Last Post: 02-04-2019, 06:14 AM
  2. Change cell format (cell color+font color) based on color of another cell
    By Dedaluss in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-30-2017, 03:27 AM
  3. Conditional format to change color of row based on data in cell
    By PJenkins in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-02-2013, 09:39 AM
  4. Replies: 0
    Last Post: 04-09-2013, 02:51 PM
  5. Replies: 0
    Last Post: 09-26-2012, 01:08 PM
  6. Replies: 3
    Last Post: 07-08-2010, 06:48 PM
  7. Conditional Format-change color of cell
    By bshelman in forum Excel General
    Replies: 3
    Last Post: 05-05-2008, 09:33 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1