Conditional Format

[wgd.roaming]

Excel 2003

XP - Professional

Highlight one or more cells to apply a Conditional Format.

Font and its size are grayed out - cannot change.

Reg, Bold, Italic work fine against the font selected for the cell.

Other conditions work - contents of cell "equal to" for example.

What am I doing wrong that forces font style and size to be grayed
out?

Wish, under one condition for selected text to be small regular font;
For another selected text, wish the display be different font and
bold.

Only font style and color are selectable.

Thoughts? A solution?

THank You!

Wayne
Sarasota, FL

 

[Gord Dibben]

Font Type and Size are simply not available under CF.

Excel developers designed it that way for some reason.

BTW...........2007 is the same.

If it is really important you would have to resort to VBA in order to change
Font Types and Sizes.


Gord Dibben MS Excel MVP

 

[wgd.roaming]

Thank You, Gord.

Font Type and Size are simply not available under CF.

Excel developers designed it that way for some reason.

BTW...........2007 is the same.

If it is really important you would have to resort to VBA in order to change
Font Types and Sizes.


Gord Dibben MS Excel MVP

 

[wgd.roaming]

The "thing" that is throwing is that the font size and style are
listed, though grayed out.

As an MS Excel MVP, pls consider what I need to do to implement a VBA
routine to effect style and size. In experienced in implementing VBA,
might there be an easy way to add the required code?

Thank You.

Regards,
Wayne
Sarasota FL

 

[Gord Dibben]

That is a standard menu. I would assume developers decided not build a special
menu just for CF?

As far as code goes.............should be fairly straightforward event code
behind a worksheet,

I would need to know what conditions you are looking to format.

You do mention certain text to be small regular and other text to be different
font type and bold.

Can you give examples and ranges where these "certain texts" may be found.?

This event code is an example of event code ................

The text in C1 is changed depending upon the values in A1 and B1

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Intersect(Target, Me.Range("A1")) Is Nothing Then Exit Sub
On Error GoTo CleanUp
Application.EnableEvents = False
If Target.Value <= Range("B1").Value Then
With Range("C1").Font
.Name = "Arial"
.Size = 10
.ColorIndex = 0
End With
End If
If Target.Value > Range("B1").Value Then
With Range("C1").Font
.Name = "Times New Roman"
.Size = 14
.Bold = True
.ColorIndex = 3
End With
End If
CleanUp:
Application.EnableEvents = True
End Sub

To see how the code works, right-click on the sheet tab and "View Code".

Copy/paste the code into that module.

Make changes to D20 and E20 to see what happens with B1

Could you use something like this?


Gord

 

[wgd.roaming]

Gord: Will send the code to work today and figure it out.

Appreciate your taking the itme.

Wayne

 

[Gord Dibben]

I hope you figured out my typos.

Should read...........make changes to A1 and B1 and see what happens with C1

When I use old code I should proof-read a little better.


Gord

 

[wgd.roaming]

Slammed at work (heavy, more or less, excel user >> real estate
administrator - Longboat Key, FL - trying for all that we can before
the gas crunch forces a serious slow down) right now - expect to work
your suggestions this weekend.

Good weekend to you, Wayne