value and formatting

Hi Gurus I found below code for changing the negative number in red. = = = = = Sub One_Way() Dim c As Range For Each c In Selection If c.Value < 0 Then c.Font.Color = vbRed Next c End Sub Source: VBA code to make negative numbers red and positive numbers black = = = = =...

Hey guys, Struggling here with a big project of mine and really need some help! So the data i get in has two columns, a and b. In a it provides me with two answers either yes or no. This tells me if this was planted or not. Column b provides me with my trees data tag. i need to find a way to...

Hi, This is my first time on this forum, so maybe I’m posting an issue of which the solution is too simple for words. I sincerely hope that this is the case ?. I made an Office 365 Excelfile in which a person has to register some data. Because I put some formulas in the file (worksheet) he/she...

Hi! Would really appreciate some help on this. I have a sheet (sheet1) with the cell «AB6» This Cell has a quite big formula to calculate values from multiple sheets and it works great. I have a macro to trigger if the cell value of AB6 =1 This macro is a “Private Sub Worksheet_Change(ByVal...

Hi, I have virtually no VBA knowledge, and am looking to copy the same selected sheets every week, and paste their values and formatting only into a new workbook. I think this can be done with a VBA macro?