Different color on cell [newbie]

  • Thread starter Thread starter Jon
  • Start date Start date
J

Jon

I would like that text is displayed in a different color, in the following
example, with the following conditional (i.e. if it evaluates to false
display text in red):

=IF(M71="Yes","No",[Red]"TBC")

Any ideas?
 
Use :
=IF(M71="Yes","No","TBC")
and use conditional formating to test the cell value.
HTH
Daniel
 
You must log in or register to reply here.

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 Color of cell 3
Coloring a cell based off the color of another cell 4
Conditional Formating based on Date 5
fill a cell color using date in one cell and "yes/no" in another c 6
Changing the color of a cell based on the color of another cell. 6
How to set color for text based on conditions? 2
How to filter rows data based on background color of individual cells 1
Conditional Statements looking at colors? 3

Back
Top