change text format dependant on formula result

S

Stu Wilkinson

can i test a cell to see if it is one of 2 results using an
=If(a1="","Unsold","sold") formula and then colour it RED dependant on result

eg result is Sold but I want to automatically colour the text RED but if the
result is Unsold leave as black text
 
N

NBVC

Use Conditonal Formatting

Select Cell(s) and go to Format|Conditional Formatting and select Cel
Value Is from 1st drop down..

enter: ="Sold"

Click Format and choose Red from the Font tab
 

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 the colour of a neighbouring cell 6
Cell text and background colour dependant on result 1
Changing the font of a cell dependant on the outcome 1
format a range dependant on another cell 2
Excel does not accept text format! 0
Conditional Formatting Help when a Cell is Blank 2
Formula for Dates and CF Colour then convert to Text 3
Cell Coloring 2

Top