Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 38
Default Conditional Formatting Font Change

In Excel 2007 I have applied Conditional Formatting to a range of cells (B1
to B100) so that the font colour changes to green if the corresponding cell
in the range D1 to D100 displays "Accepted". Trouble is, Excel has made the
font "Cambria". The background / normal cell font is Arial. I cannot
control the font in Conditional Formatting, but Excel seems to want to change
it for me. I've never used Cambria.

What's going wrong?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,276
Default Conditional Formatting Font Change

Hi,
Go to conditional formating, manage rules, choose your formula and see if it
has not Cambria assigned

"Hugh" wrote:

In Excel 2007 I have applied Conditional Formatting to a range of cells (B1
to B100) so that the font colour changes to green if the corresponding cell
in the range D1 to D100 displays "Accepted". Trouble is, Excel has made the
font "Cambria". The background / normal cell font is Arial. I cannot
control the font in Conditional Formatting, but Excel seems to want to change
it for me. I've never used Cambria.

What's going wrong?

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
changing font using conditional formatting Milind Keer[_2_] Excel Discussion (Misc queries) 1 November 6th 09 02:27 PM
Font and Size Disabled in Conditional Formatting ?? monir Excel Worksheet Functions 6 December 14th 08 06:15 PM
Change Font Color Based on Conditional Formatting tj Excel Worksheet Functions 8 October 11th 08 02:08 AM
Conditional formatting font Harley Excel Discussion (Misc queries) 2 June 28th 05 06:43 PM
why cant i change font size when i use conditional formatting? cbwindycity Excel Discussion (Misc queries) 1 January 6th 05 10:45 PM


All times are GMT +1. The time now is 10:41 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"