Format within a Function

J

JAC

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?
 
B

Bernard Liengme

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
 

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

Similar Threads

How to format Text by function 5
function to populate a cell where formula is NOT located 6
Using If function with text values 4
If function using cell format as the condition 2
Attempting to Copy a IF Function 3
TRUE/FALSE function in IF statement 2
Ms Excel Multiple Logical Test Function 0
How do i trouble shoot an IF function 2

Top