Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Hague2
 
Posts: n/a
Default 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
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

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



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
Formula for Formatting Fonts Jane Excel Discussion (Misc queries) 1 April 12th 05 03:51 AM
difficulty with conditional formatting Deb Excel Discussion (Misc queries) 0 March 23rd 05 06:13 PM
conditional formatting question Deb Excel Discussion (Misc queries) 0 March 23rd 05 02:07 AM
Copy conditional formatting across multiple rows? Gil Excel Discussion (Misc queries) 1 January 11th 05 11:27 AM
Conditional formatting not available in Excel BAB Excel Discussion (Misc queries) 2 January 1st 05 03:33 PM


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

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

About Us

"It's about Microsoft Excel"