Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JAC JAC is offline
external usenet poster
 
Posts: 15
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 563
Default 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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
format function fhl Excel Worksheet Functions 8 May 2nd 08 05:30 PM
how do you write format results of a function within a function? sangee Excel Worksheet Functions 3 June 14th 07 12:45 AM
format & function yshridhar Excel Discussion (Misc queries) 3 May 10th 07 05:35 AM
date format and the RIGHT function Rich Hayes Excel Worksheet Functions 1 December 19th 05 02:22 PM
the function FORMAT() Jonas Excel Discussion (Misc queries) 1 January 28th 05 03:53 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"