conditional formatting font size

[Kyle775]

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...

 

[erik.van.geit]

Hello, Kyle775,

this works for me

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]

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]

There is an Access forum just select it from the Jump to dropdown.

How are you trying the conditional formatting in Access?

 

[Kyle775]

i was using the conditional function menu
ive changed that to the OnFormat event of the detail section