.tintandshade

Hello! I am trying to create a Macro/VBA to conditionally format text. I have 30+ text examples I'd like to highlight all the same color. For example, I'd like to highlight: "abc called", "abc understands", "abcdef called", etc. I don't know how to do this other than recording each and every...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...

'********** Step Through Rows Backwards ***************** lastrow = Cells(Rows.Count, "C").End(xlUp).Row For myrow = lastrow To 6 Step -1 Columns("B:C").Select Selection.FormatConditions.AddUniqueValues Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority...

Hello, I am using VBA to apply conditional formatting to a column however, I only want the conditional formatting to be applied to cells which already fill in them and skip any cells with no fill. Below is my current code. Sub ApplyBAandCertConditionalFormatting() With Sheet2 With...

Hello, I am trying to create a dynamic worksheet name in my dynamic range borders macro. I got the range borders to be dynamic but now I am struggling with creating a dynamic worksheet name that I do not have to change for each report I run. This is the code I have: Sub DynamicRangeBorders()...

I use Range("A7", "N" & lastrow).Select Selection.Borders(xlDiagonalDown).LineStyle = xlNone Selection.Borders(xlDiagonalUp).LineStyle = xlNone With Selection.Borders(xlEdgeLeft) .LineStyle = xlContinuous .ColorIndex = 0 .TintAndShade = 0 .Weight =...

Hi Guys, I'm trying to apply conditional formatting on a script I've recorded for data exported from another program. So the conditional formatting I'm trying to apply is to color values between 70%-89% yellow and 90%-100% red. When applying these conditions the entire row is highlighted...

Hi, I would like to add borders to all cells within the range of columns U:AE, starting from row 5, all the way down to the row where column B is still populated with data. Columns U:AE will at times be blank, hence I need to reference another column that will always have data in. Finally...

hi, this is my current code: ' ' importdata Macro ''workbooks("lap_lookup.xlsm").sheets("info").unProtect Workbooks.Open Filename:="C:\123\123_data.xlsx" Range("A2:H3007").Select Selection.Copy Windows("123_lookup.xlsm").Activate Range("A2").Select ActiveSheet.Paste...

I need to paste Format conditional formatting to every 6th row with the starting range ("I22:AM22") This has to continue until the equivalent range (every 6th row) in cell "A22" is blank Thanks for any help! Range("I22:AM22").Select Range("I22").Activate Selection.FormatConditions.Add...

Hi all, I'm not sure if anyone will be able to help me, I have a report that has a random amount of lines where I am using VBA code to format it in the way I need. This issue is that some of the formatting code stops at row 2501 and I am not able to see why - the code I have is below...

I have a macro that I use to change the fill color of cells, hide and unhide columns, and print 1 copy of each worksheet in the file. However, I need to manually select the printer and close out of the 'print' screen before I activate it. Otherwise, it will try to print from the other connected...

Hello, I recorded a macro. For some reason, it is copying columns F to M (starting at row 6) and pasting it in columns N to AC (t pastes all 9 columns 3 times). Since this macro is primarily just formatting, I am able to read most of the macro coding. I am not able to see anywhere within...

Hello, I have a simple excel sheet with all of 2017 calendar dates on it from A5:A369. When I open the excel sheet, it finds today's date in column A and bolds the cell, increases the size and borders it. 1. What I would like to add to the current code is: once it finds the date, I would like...

Hello everyone on MrExcel, I thank in advance anyone that will help me resolve my problem. At work my collegue uses the below Macro to extract data from an Excel generated by a program (HP Quality Center, in postprocessing). For some reason, the Macro works for him but not for me. He uses Excel...