Format color in formula in Excel

4charity
4charity used Ask the Experts™
on
I am writing a formula in a cell, to translate information from one sheet to another. In doing that, I want the "TBD*" to show up in RED. How can I add that to my formula? This is what I have:

=IF(GoTos!G4="A","Yes",IF(GoTos!G4="B","Yes*",IF(GoTos!G4="TBD","TBD*","")))
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Use Conditional Formatting. Please take a look at the attached image and sample file.

jppinto
Capture.JPG
ConditionalFormatting2.xlsx
You can use condiditional formatting for the cell which has the formula.

In 2003

Format > conditional formatting > Cell Value is > Equal to > "TBD*"

and then set a desired format from the Format button.

in later versions it is on the Home toolbar but I do not remember the sequences thereafter but maybe you can figure it out based on the above for 2003
Top Expert 2008
Commented:
You can't put this in your formula, but you can use Conditional Formatting to format cells ="TBD" as red.

Thomas

Author

Commented:
Perfect! Thanks....

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial