+ Reply to Thread
Results 1 to 4 of 4

Upon entry in any cell, need some fill colors to change if certain conditions met

  1. #1
    Forum Contributor
    Join Date
    07-02-2012
    Location
    Florida
    MS-Off Ver
    Home -Excel 2007, Work 2016
    Posts
    254

    Upon entry in any cell, need some fill colors to change if certain conditions met

    Upon entry in any cell, need that cell's fill color to go to grey and the cell to it's right to go to red, if certain conditions are met.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Upon entry in any cell, need some fill colors to change if certain conditions met

    What are the conditions?
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    07-02-2012
    Location
    Florida
    MS-Off Ver
    Home -Excel 2007, Work 2016
    Posts
    254

    Re: Upon entry in any cell, need some fill colors to change if certain conditions met

    Thanks for you question -
    It may change but right now it is if the left 3 digits of the cell to the left of where the entry is made are equal to the left 3 digits of the cell to the right of where the entry is made.
    Bill

  4. #4
    Forum Contributor
    Join Date
    07-02-2012
    Location
    Florida
    MS-Off Ver
    Home -Excel 2007, Work 2016
    Posts
    254

    Re: Upon entry in any cell, need some fill colors to change if certain conditions met

    Am I not getting solutions because of the conditions?

+ 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. Change bar chart fill colors to match the color of a random cell
    By gwbe in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-03-2014, 08:12 PM
  2. Change Cell Fill Color Based on Colors in 2 Columns
    By djkante in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-05-2010, 08:07 PM
  3. [SOLVED] Cell fill colors in Excel change when copying to a new book
    By jkbond67 in forum Excel General
    Replies: 2
    Last Post: 07-31-2006, 04:53 PM
  4. Can't format font colors or cell fill-in colors
    By canoeron in forum Excel General
    Replies: 3
    Last Post: 08-22-2005, 07:05 PM
  5. Replies: 1
    Last Post: 02-05-2005, 02:06 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