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

**Jeankartel** · 08-15-2019, 06:27 PM

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

**alansidman** · 08-15-2019, 06:48 PM

Conditional Formatting as shown below.

**FDibbins** · 08-15-2019, 06:49 PM

excel does not "see" colors, they are formatting, and excel works on data.

You would (as you suggested) use Conditional Formatting for this, based on the values in B5 and B3. Something like...

New Rule/Use Formula/ =B5 > B3 format fill to your desired color

**FDibbins** · 08-15-2019, 06:50 PM

@ Alan, OP said > not > =

**alansidman** · 08-15-2019, 06:53 PM

Got it Ford. Could not get the conditional formatting to work without the >=. I was never very good at CF. Always gives me agina.

**Jeankartel** · 08-15-2019, 06:54 PM

Hi Alan, thanks so much! that works and so simple

You are a champion.

**FDibbins** · 08-15-2019, 07:02 PM

Heyyyy I gave the same suggestion (1 minute later)

(just kidding - as long as you got what you needed

)

**Jeankartel** · 08-15-2019, 07:04 PM

Hi Fdibbins, you are also a legend! You gave me some more background information as well so i gave you some reputation as well. Your prompt help is much appreciated

**alansidman** · 08-15-2019, 07:06 PM

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

**FDibbins** · 08-15-2019, 07:16 PM

Thanks for the rep and the kind words - always appreciated.

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

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

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

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

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

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Changing a cell that has a colour formatted to another colour after a period of time

Changing chart colour to reflect colour of cell

[SOLVED] Changing the colour of a cell based on PART of the text of the cell

Changing the colour of a cell based on the colour of another cell

[SOLVED] Macro to change text colour of adjacent cell to the same text colour as target cell

Changing a cell's colour basing on other cells' colour

Changing cell fill colour based on date in cell - Multiple rows

Bookmarks

Bookmarks

Posting Permissions