Solved Changing colour of text in a cell

April 9, 2013 at 02:26:49
Specs: Windows XP
I would like to change the colour of text in a cell when the text changes based on the value in another cell. I am able to change the text in cell (in my case "A49") depending on the value in cell "H49" using the "IF" function. I have formatted a range of rows including row 49 so that it normally shows in red. However, I would like the colour of the text to change to black in cell "A49"and if possible also the background colour to another specified colour. I have tried to specify the colour in the "IF" function table if the value in cell "H49" is false but may be I am not doing it correctly. Any help will be appreciated.

XEL-LEARNER


See More: Changing colour of text in a cell

Report •

#1
April 9, 2013 at 06:08:41
✔ Best Answer
Have you tried Conditional Formatting with the following Rule? It works for me.

=H49=FALSE

If H49 will ever be empty, Conditional Formatting might pick that up as FALSE (FALSE = 0) so you might want to use this:

=AND(H49<>"",H49=FALSE)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
April 10, 2013 at 03:09:11
Thanks for the prompt reply once again, Derbydad03. In the formula you have suggested where is the command to change the colour of the text? Cell "A49" is already formatted with the "IF" Function which changes the Text automatcally. Can another formula be added to the same cell, In this case to change the colour of the same Text to a specified colour? Also to change the background colour in the cell?

XEL-LEARNER


Report •

#3
April 10, 2013 at 04:15:30
Are you familiar with the Conditional Formatting feature? If not, look it up in the Excel help files or do a Google search.

CF is set up differently depending on which version of Excel you are using.

The CF feature has a wizard that allows you to enter formulas that will return either TRUE or FALSE. When the formula returns TRUE, the formatting that you chose via the wizard is applied.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
April 10, 2013 at 04:21:48
Thanks, I will give it a try and let you know how I get on.


Report •

Ask Question