conditional formatting font size

Kyle775

Board Regular
Joined
Feb 16, 2005
Messages
230
currently i have a sheet that bolds an entire row if the value in column G is greater than 29. i would like the font to be increased in size based on the same condition. however, as im sure many of you know, conditional formatting does not allow a change in font size (not to mention many other useful formatting options)

i have looked around and found that VBA must be used... however i am not every proficient in vba. any help on this would be great...
 

Some videos you may like

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
Hello, Kyle775,

this works for me
Code:
Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
Dim Rng As Range
Dim Cell As Range

Set Rng = Intersect(Target, Columns(7))
If Rng Is Nothing Then Exit Sub

    For Each Cell In Rng
    Cell.EntireRow.Font.Size = IIf(Cell > 29, 14, 10)
    Next Cell

End Sub
and for you ?

kind regards,
Erik
 

Kyle775

Board Regular
Joined
Feb 16, 2005
Messages
230
i dont know if this is good news or bad news but i have switched the entire project to access... i still need something that will achieve this result only in an access report. so far my conditional format will not even work... i cant get the entire row to bold if it is greater than 29. is this the right place to discuss?

excuse me....! thanks for your help!!
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,089
Office Version
  1. 365
Platform
  1. Windows
There is an Access forum just select it from the Jump to dropdown.

How are you trying the conditional formatting in Access?
 

Kyle775

Board Regular
Joined
Feb 16, 2005
Messages
230
i was using the conditional function menu
ive changed that to the OnFormat event of the detail section
 

Watch MrExcel Video

Forum statistics

Threads
1,119,144
Messages
5,576,333
Members
412,717
Latest member
EVENTCATERING
Top