ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Applying Formatting (Fonts) in Formuals (https://www.excelbanter.com/excel-discussion-misc-queries/23083-applying-formatting-fonts-formuals.html)

Hague2

Applying Formatting (Fonts) in Formuals
 
When using an IF statement (or any formula) can you include Formatting? For
example, Yes answers GREEN and No answers RED. I believe you can do this
later using the conditional formatting, but can you include a formula within
the IF statement's formula?
Thanks

Bob Phillips

No, you need conditional formatting for that.

Look up 'Highlight cells that meet specific conditions' in the Answer
wizard in help

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Hague2" wrote in message
...
When using an IF statement (or any formula) can you include Formatting?

For
example, Yes answers GREEN and No answers RED. I believe you can do this
later using the conditional formatting, but can you include a formula

within
the IF statement's formula?
Thanks





All times are GMT +1. The time now is 02:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com