Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 10
Default Different Font Color for results evaluated by "IF"

How to print the evaluated results from an "IF"
function in different font colors for the two choices??

  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,268
Default Different Font Color for results evaluated by "IF"

You can apply format conditional formatting, select cell value equal to
the first "choice", format the font to your liking, then add a second
condition and repeat but use the second "choice" and another font colour

--
Regards,

Peo Sjoblom


"exceltyro" wrote in message
...
How to print the evaluated results from an "IF"
function in different font colors for the two choices??



  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 10
Default Different Font Color for results evaluated by "IF"

Thanks Peo.

"Peo Sjoblom" wrote:

You can apply format conditional formatting, select cell value equal to
the first "choice", format the font to your liking, then add a second
condition and repeat but use the second "choice" and another font colour

--
Regards,

Peo Sjoblom


"exceltyro" wrote in message
...
How to print the evaluated results from an "IF"
function in different font colors for the two choices??




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
Data entry "+" results in "294" in XLS jaak de vuyst Excel Discussion (Misc queries) 1 October 22nd 06 06:18 PM
HELP on "left","right","find","len","substitute" functions serene83 Excel Discussion (Misc queries) 5 June 27th 06 02:23 AM
Need column evaluated to count total of occurrences of "Y". How? learning Excel Worksheet Functions 2 June 12th 06 01:55 AM
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next BCB New Users to Excel 7 May 13th 06 10:02 PM
Any IF(A2=font color=red", "1", "0") in excel? Or a way to do it? Steve Excel Discussion (Misc queries) 1 November 7th 05 02:48 PM


All times are GMT +1. The time now is 06:39 PM.

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"