Conditional formatting & borders

[davej311]

I'd like to add a border to certain cells when my conditional formula is true, however the lines are quite thin & not very noticeable, any way I can thicken them up, like you can when formatting manually?

 

[Joe4]

Conditional Formatting seems to have a limited number of options when it comes to border thickness.
Alternatives include choosing something other than borders to indicate which cells are conditionally formatted, or use VBA instead of Conditional Formatting.

 

[davej311]

I guessed as much, unfortunately I'm not good on VBA, maybe it's about time I learnt

Thanks!

 

[Joe4]

I am thinking you probably want a "Worksheet_Change" event procedure in VBA. This is code that runs automatically upon specified cells being manually updated.
Chip Pearson wrote a nice write-up on Events in Excel VBA here: http://www.cpearson.com/excel/Events.aspx

Of course, we can always help you here too, if you just post the details of how you would like it to work.