Formula that yields colors to "yes" and "no"

Tech Teacher
NewLounger
Posts: 9
Joined: 21 Aug 2014, 18:33

Formula that yields colors to "yes" and "no"

Post by Tech Teacher »

Is there a formula that causes the text or cell change to a color depending on a yes or no answer?

Thanks in advance....

User avatar
StuartR
Administrator
Posts: 12577
Joined: 16 Jan 2010, 15:49
Location: London, Europe

Re: Formula that yields colors to "yes" and "no"

Post by StuartR »

Simple conditional formatting should be able to do this for you
StuartR


User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Formula that yields colors to "yes" and "no"

Post by HansV »

Welcome to Eileen's Lounge!

You can use conditional formatting for this:
- Select the cell or cells.
- On the Home tab of the ribbon, click Conditional Formatting > Highlight Cells Rules > Equal To...
S0029.png
- In the dialog that appears, enter Yes in the box, then select a format from the dropdown to the right. If you want something not listed, select Custom Format...
S0030.png
- Click OK.

Repeat the above steps, but enter No in the box, and select different formatting.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

Tech Teacher
NewLounger
Posts: 9
Joined: 21 Aug 2014, 18:33

Re: Formula that yields colors to "yes" and "no"

Post by Tech Teacher »

Thanks for the information. However, I want to be able to do so without conditional formatting....I would like to have a real formula to change the color. Is that possible?

Thanks,

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Formula that yields colors to "yes" and "no"

Post by HansV »

I'm sorry, formulas cannot set formatting.
Best wishes,
Hans

Tech Teacher
NewLounger
Posts: 9
Joined: 21 Aug 2014, 18:33

Re: Formula that yields colors to "yes" and "no"

Post by Tech Teacher »

Thank you very much...