Results 1 to 2 of 2

Changing cell colour based on another cell's value, but the latter cell changes

Threaded View

  1. #1
    Registered User
    Join Date
    01-10-2017
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    3

    Changing cell colour based on another cell's value, but the latter cell changes

    Hi all
    Forgive me if this is a really basic formula but I'm trying to make a certain cell automatically change colour (to green) based on whether it meets or exceeds the value of a different cell. The reason I'm struggling is that the latter cell changes its value every few days so I can't put in a simple conditional-format.

    In the example, the figure in C3 is my target, which changes twice a week.

    The figure in F3 is the figure that I want to automatically highlight in green once it equals of exceeds that in C3.

    Any help would be hugely appreciated....
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Changing text colour in a cell based on value or colour of another cell.
    By Jeankartel in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-15-2019, 07:16 PM
  2. [SOLVED] changing cell colour based on other and multiple cell values
    By COL_MCC in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-28-2019, 08:43 AM
  3. [SOLVED] Changing the colour of a cell based on PART of the text of the cell
    By Sanglorian in forum Word Programming / VBA / Macros
    Replies: 4
    Last Post: 11-11-2014, 12:48 AM
  4. [SOLVED] Changing the cell colour based on what is input in another cell.
    By MissMay in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-21-2013, 10:21 AM
  5. Changing the colour of a cell based on the colour of another cell
    By Pete2931 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-11-2012, 03:35 AM
  6. Changing cell fill colour based on date in cell - Multiple rows
    By ExcelNewb2010 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-26-2010, 07:30 AM
  7. Changing Cell Fill Colour based on another cell value
    By MoonWeazel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-02-2008, 10:15 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