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

Top