Automating text colour changes in Excel

A

Al

How do I get the text in a cell to automatically change colour when a
particular formula or function result is achieved. E.g. logical function
result "TRUE" auto text colour change to green?
 
R

Ragdyer

This feature in XL is called "Conditional Formatting".

Look it up in the Help files, and post back if you need help.
 
R

Rick Rothstein \(MVP - VB\)

Click on Format/Conditional Formatting on Excel's menubar. For evaluation a
formula as TRUE, click the first combo box and pick "Formula Is" from its
drop down; type your formula (with the leading equal sign) in the type in
field; then click the Format button; select the Patterns tab and pick your
cell color; finally, OK your way back to the worksheet.

Rick
 

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

Change background colour 3
auto change cell text colour resulting from a condition 2
Formula for Dates and CF Colour then convert to Text 3
Cell Coloring 2
how do i change cell text colour based on value in other cell 2
CONDITIONAL FORMATTING IN EXCEL 2010 1
date text to change colour when it gets over six months 1
How to auto text colour change to green if logical function true? 1

Top