ExcelBanter - Different colors in a cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Different colors in a cell (https://www.excelbanter.com/excel-discussion-misc-queries/237153-different-colors-cell.html)

Boots

Different colors in a cell

Say I have the formula =IF(B2="T","Yes","No") . Can I set up something so the
"Yes" result is blue and the "No" result is red?
--
Boots

Per Jessen

Different colors in a cell

Look at Conditional formatting from the Format menu.

Please write again if you need further help.

---
Per

"Boots" skrev i meddelelsen
...
Say I have the formula =IF(B2="T","Yes","No") . Can I set up something so
the
"Yes" result is blue and the "No" result is red?
--
Boots

All times are GMT +1. The time now is 09:44 PM.