ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Format within a Function (https://www.excelbanter.com/excel-worksheet-functions/253040-format-within-function.html)

JAC

Format within a Function
 
I am using the "IF" function, and want to have a different format for the
different values. For example, if the [logical test] is true, I want to say
"Window," but if the [logical test] is false, I want to also say "Window" but
with a strikethrough through it or some different format (ie, bold,
underline, etc...). Is this possible?

Bernard Liengme[_2_]

Format within a Function
 
Functions can return VALUES they cannot change formats
Have a look at Conditional Formats in Help and come back if you need help
with that topic
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"JAC" wrote in message
...
I am using the "IF" function, and want to have a different format for the
different values. For example, if the [logical test] is true, I want to
say
"Window," but if the [logical test] is false, I want to also say "Window"
but
with a strikethrough through it or some different format (ie, bold,
underline, etc...). Is this possible?




All times are GMT +1. The time now is 12:05 PM.

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