auto change cell text colour resulting from a condition

G

Guest

Can Excel automatically change the colour of the font in Cell by using a
conditional formula? In fact, I just want to highlights the result of a
formula.

Example: I want to text to in Red colour if the result is Ture, otherwise
is in Blue colour.

Thanks
 
G

Gord Dibben

Cannot be done through formula only.

That's what Format>Conditional Formatting is used for.

Select the cell and Format>CF>Cell value is: type true in the dialog then
format>font to red color.

As far as "otherwise" goes just format the font as blue normally.

Then you will have either red or blue colored font.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automating text colour changes in Excel 2
Change the colour 1
Change colour in cell 1
Formula for Dates and CF Colour then convert to Text 3
condition formatting with formula 1
Cell Coloring 2
cell vlue based on cell back colour 6
how do i change cell text colour based on value in other cell 2

Top