Posts by ANB_Excel

Re: Format Row Based On Text Value

[COLOR="Red"]THANK YOU[/COLOR] The Code worked perfectly!
I just needed to remove the tint and shade property.
Thank you again.
ANB

Re: Format Row Based On Text Value

Simon [COLOR="Red"]Thank You[/COLOR] worked perfect!
Just had to remove the Tint and Shade property.

Is there a way to format any row in the workbook based on text value in VBA?

e.g. If I type "BLANK" in any row of a worksheet, then the certain cells in that particular row will Format Borders xlDiagonalUp (D:G,K).

[Blocked Image: http://i51.photobucket.com/albums/f375/trillskill/XL_blank.gif]