Results 1 to 10 of 10

Changing text colour in a cell based on value or colour of another cell.

Threaded View

Jeankartel Changing text colour in a... 08-15-2019, 06:27 PM
alansidman Re: Changing text colour in a... 08-15-2019, 06:48 PM
Jeankartel Re: Changing text colour in a... 08-15-2019, 06:54 PM
FDibbins Re: Changing text colour in a... 08-15-2019, 06:49 PM
FDibbins Re: Changing text colour in a... 08-15-2019, 06:50 PM
alansidman Re: Changing text colour in a... 08-15-2019, 06:53 PM
FDibbins Re: Changing text colour in a... 08-15-2019, 07:02 PM
Jeankartel Re: Changing text colour in a... 08-15-2019, 07:04 PM
alansidman Re: Changing text colour in a... 08-15-2019, 07:06 PM
FDibbins Re: Changing text colour in a... 08-15-2019, 07:16 PM
  1. #1
    Registered User
    Join Date
    12-31-2018
    Location
    New Zealand
    MS-Off Ver
    10
    Posts
    7

    Changing text colour in a cell based on value or colour of another cell.

    Hi guys and girls, im wanting to be able to change the colour of text in a cell based on the value of another cell. So in my simple attached excel file. I would like cell C5 to have red text if cell B5 is greater than cell B3.
    I assume its maybe some conditional formatting with an "if" formula but im not sure the correct way to write this.
    Alternatively if Cell C5 could be changed to red text if cell B5 was red text that would work as well. Whichever way works would be ok. Thanks for any help that can be provided

    Kind regards John
    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. Replies: 11
    Last Post: 01-16-2018, 09:03 AM
  2. Changing chart colour to reflect colour of cell
    By hillwalker11 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-13-2016, 03:12 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. 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
  5. [SOLVED] Macro to change text colour of adjacent cell to the same text colour as target cell
    By kayoke in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 06-28-2012, 04:18 AM
  6. Changing a cell's colour basing on other cells' colour
    By rhua5436 in forum Excel General
    Replies: 11
    Last Post: 09-23-2010, 05:49 AM
  7. 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

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